home *** CD-ROM | disk | FTP | other *** search
/ Supercompiler 1997 / SUPERCOMPILER97.iso / Delphi 3.0 / DATA.Z / dbx.dbi < prev    next >
Encoding:
Borland DataBase Explorer Information  |  1997-01-30  |  118.0 KB  |  2,662 lines
  1.  
  2.  
  3. [Version]
  4. DbXName="SQL Explorer"
  5. DbXDR=True
  6. DbXVersion=1.03
  7.  
  8. [Properties]
  9. DEFAULT DRIVER:Values=Closed,PARADOX,DBASE,ASCIIDRV
  10. NET PROTOCOL:Values1=Closed,TNS,TCP/IP,SPX/IPX,NETBIOS,NAMED PIPES,DECNET,3270,VINES
  11. NET PROTOCOL:Values2=APPC,ASYNC
  12. OPEN MODE:Values=Closed,READ/WRITE,READ ONLY
  13. SHARE MODE:Values=Closed,EXCLUSIVE,SHARED
  14. STRICTINTEGRTY:Values=Closed,FALSE,TRUE
  15. SQLPASSTHRU MODE:Values=Closed,NOT SHARED,SHARED AUTOCOMMIT,SHARED NOAUTOCOMMIT
  16. VENDOR INIT:Values=Open,ORANT71.DLL,ORA72.DLL,ORA73.DLL
  17. LIST SYNONYMS:Values=Closed,NONE,ALL,PRIVATE
  18. BLOB EDIT LOGGING:Values=Closed,FALSE,TRUE
  19. ENABLE SCHEMA CACHE:Values=Closed,FALSE,TRUE
  20. ENABLE BCD:Values=Closed,FALSE,TRUE
  21. ENABLE INTEGERS:Values=Closed,FALSE,TRUE
  22. LOCAL SHARE:Values=Closed,FALSE,TRUE
  23. AUTO ODBC:Values=Closed,FALSE,TRUE
  24. FOURDIGITYEAR:Values=Closed,FALSE,TRUE
  25. YEARBIASED:Values=Closed,FALSE,TRUE
  26. LEADINGZEROM:Values=Closed,FALSE,TRUE
  27. LEADINGZEROD:Values=Closed,FALSE,TRUE
  28. TWELVEHOUR:Values=Closed,FALSE,TRUE
  29. SECONDS:Values=Closed,FALSE,TRUE
  30. MILSECONDS:Values=Closed,FALSE,TRUE
  31. LEADINGZERON:Values=Closed,FALSE,TRUE
  32. COLLCHAR:Values=Closed,0,1,2
  33. DBNLS:Values=Closed,0,1,2
  34. SQLQRYMODE:Values=Closed,LOCAL,SERVER
  35.  
  36. MSSQL:Identity=select substring(@@version,1,charindex(char(0x0a),@@version)-1)
  37. MSSQL:IdentityRE=SQL Server [^0-9]*([0-9]+)\.
  38.  
  39. Sybase:Identity=select @@version
  40. Sybase:IdentityRE=SQL Server/([0-9]+)\.
  41.  
  42. Oracle:Identity=select 'Oracle ' || VERSION_TEXT from SM$VERSION
  43. Oracle:IdentityRE=([0-9]+\.[0-9]*)
  44. Oracle:IdentityMap:7.3=7.2
  45.  
  46. Informix:Identity=select 'Informix ' || owner from informix.systables where tabid=99
  47. Informix:IdentityRE=([0-9]+)\.
  48.  
  49. DB2:IdentityMap:DB2/2=Common Server
  50. DB2:IdentityMap:DB2/NT=Common Server
  51. DB2:IdentityMap:DB2/AIX=Common Server
  52.  
  53. [DATAREP Properties]
  54. BDETypes:Values1=Closed,1=ZString,2=Date,3=Blob,4=Bool,5=Int16,6=Int32
  55. BDETypes:Values2=7=Float,8=BCD,9=Bytes,10=Time,11=TimeStamp,12=UInt16
  56. BDETypes:Values3=13=UInt32,14=IEEE Float,15=VarBytes,16=LockInfo
  57.  
  58. BDESubTypes:Values1=Closed,0=,1=Password,21=Money,22=Memo,23=Binary
  59. BDESubTypes:Values2=24=Formatted Memo,25=OLE Object,26=Graphic
  60. BDESubTypes:Values3=27=DBase OLE Object,28=Typed Binary,29=Auto Increment
  61.  
  62. TScale:Values=Open,0=
  63. TBooleanTF:Values=Closed,0=False,-1=True
  64. TAlignment:Values=Closed,0=taLeftJustify,1=taRightJustify,2=taCenter
  65.  
  66. TFieldType:Values1=Closed,0=ftUnknown,1=ftString,2=ftSmallint,3=ftInteger
  67. TFieldType:Values2=4=ftWord,5=ftBoolean,6=ftFloat,7=ftCurrency,8=ftBCD
  68. TFieldType:Values3=9=ftDate,10=ftTime,11=ftDateTime,12=ftBytes
  69. TFieldType:Values4=13=ftVarBytes,14=ftAutoInc,15=ftBlob,16=ftMemo
  70. TFieldType:Values5=17=ftGraphic,18=ftFmtMemo,19=ftParadoxOle
  71. TFieldType:Values6=20=ftDBaseOle,21=ftTypedBinary
  72.  
  73. TBlobType:Values1=Closed,15=ftBlob,16=ftMemo,17=ftGraphic,18=ftFmtMemo
  74. TBlobType:Values2=19=ftParadoxOle,20=ftDBaseOle,21=ftTypedBinary
  75.  
  76. DRDATABASES:Reference="Databases"
  77. DREXTFIELDS:Reference="Attribute Sets"
  78. DBTABLES:Reference="Tables"
  79. TABLEFLDS:Reference="Fields"
  80. FLDEXTFIELD:Reference="Attribute Set"
  81. EXTFIELDFLDS:Reference="Referencing Fields"
  82. PARENTEXTFIELD:Reference="Based On"
  83. CHILDEXTFIELD:Reference="Referencing Attribute Sets"
  84. TABLECONSTRS:Reference="Check Constraints"
  85.  
  86. DATABASE:Category=Database
  87. DATABASE:NameRE=.*
  88. DATABASE:Attrs=DBPATH="Path"::-E,DBTYPE="Type"::-E
  89.  
  90. TABLE:Category=Dataset
  91. TABLE:NameRE=.*
  92. TABLE:Attrs=PATH=:0,DRIVERTYPE="Type"::-E,ISFILE=:0,ISVIEW=:0,ISSYNONYM=:0
  93.  
  94. CONSTRAINT:NameRE=.*
  95.  
  96. FIELD:Category=Column
  97. FIELD:Attrs1=PHYTYPE="Physical Type"::-E
  98. FIELD:Attrs2=LOGTYPE="Logical Type"::-E:::VM=BDETypes
  99. FIELD:Attrs3=LOGSUBTYPE="Logical Subtype"::-E:::VM=BDESubTypes
  100. FIELD:Attrs4=UNITS1="Size"::-E
  101. FIELD:Attrs5=UNITS2="Scale"::-E:::VM=TScale
  102. FIELD:Attrs6=DEFVAL=:2:-E,MINVAL=:2:-E
  103. FIELD:Attrs7=MAXVAL=:2:-E
  104. FIELD:Attrs8=REQUIRED=:2:-E
  105. FIELD:Attrs9=READONLY=:2:-E
  106.  
  107. EXTFIELD:Attrs1=ALIGNMENT=:::::VM=TAlignment,READONLY=:::::VM=TBooleanTF
  108. EXTFIELD:Attrs2=REQUIRED=:::::VM=TBooleanTF,VISIBLE=:::::VM=TBooleanTF
  109. EXTFIELD:Attrs3=TRANSLITERATE=:::::VM=TBooleanTF,BLOBTYPE=:::::VM=TBlobType
  110. EXTFIELD:NameRE=.*
  111.  
  112. [Standard Properties]
  113. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  114. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  115. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  116. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  117. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  118. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  119. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  120. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  121. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  122. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  123. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  124. FamilyMemberType:Values1=Closed,0="Unknown",1="Table",2="Index",3="Form",4="Report"
  125. FamilyMemberType:Values2=5="Validity Checks",6="Secondary Index",7="Secondary Index"
  126. FamilyMemberType:Values3=8="Blob File"
  127.  
  128. Standard:Objects=O:C:0M::"Tables":Table
  129.  
  130. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  131. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  132. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  133. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  134. Table:Dataset5=PROTECTED=Word,VALID=Word
  135.  
  136. Table:Category=Dataset
  137. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  138. Table:Attrs2=DATE="Date"
  139. Table:Attrs3=TIME="Time"
  140. Table:Attrs4=VERSION="Version":2
  141. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  142. Table:Attrs6=STRUCTURE="Structure":2
  143. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  144. Table:Name=FILENAME,EXTENSION
  145. Table:Objects1=O:P:1M::"Fields":Column
  146. Table:Objects2=O:O:0M::"Indices":Index
  147. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  148. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  149. Table:Objects5=O:O:0M::"Security Specs":Security
  150. Table:Objects6=O:C:1M::"Family Members":Family
  151.  
  152. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  153. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  154. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  155.  
  156. Column:Category=Column
  157. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  158. Column:Attrs2=LENGTH="Physical Length"
  159. Column:Name=NAME
  160.  
  161. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  162. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  163. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  164. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  165. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  166. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  167.  
  168. Index:Category=Index
  169. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  170. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  171. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  172. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  173. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  174. Index:Attrs6=FORMAT="Format":2
  175. Index:Attrs7=BLOCKSIZE="Block Size":2
  176. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  177. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  178. Index:Attrs10=EXPRESSION="Expression":2:N
  179. Index:Attrs11=CONDITION="Subset Condition":2:N
  180. Index:Name=NAME
  181. Index:OnAfterLoad=GetIndexInfo
  182.  
  183. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  184. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  185. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  186. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  187.  
  188. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  189. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  190. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  191. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  192. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  193. ValCheck:Attrs6=PICTURE="Picture":2:N
  194. ValCheck:Name=FIELDNUM
  195.  
  196. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  197.  
  198. Family:Attrs1=TYPE="Type":1::::VM=FamilyMemberType
  199. Family:Attrs2=NAME="Object Name":1
  200. Family:Name=FILENAME
  201.  
  202. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  203. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  204. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  205.  
  206. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  207. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  208. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  209. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  210. Reference:Name=NAME
  211. Reference:OnAfterLoad=GetReferenceInfo
  212.  
  213. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  214. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  215.  
  216. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  217. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  218. Security:Name=PASSWORD
  219.  
  220. [MSAccess Properties]
  221. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  222. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  223. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  224. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  225. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  226. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  227. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  228. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  229. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  230. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  231. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  232.  
  233. MSAccess:Objects=O:C:0M::"Tables":Table
  234.  
  235. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  236. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  237. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  238. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  239. Table:Dataset5=PROTECTED=Word,VALID=Word
  240.  
  241. Table:Category=Dataset
  242. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  243. Table:Attrs2=DATE="Date"
  244. Table:Attrs3=TIME="Time"
  245. Table:Attrs4=VERSION="Version":2
  246. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  247. Table:Attrs6=STRUCTURE="Structure":2
  248. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  249. Table:Name=FILENAME,EXTENSION
  250. Table:Objects1=O:P:1M::"Fields":Column
  251. Table:Objects2=O:O:0M::"Indices":Index
  252. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  253. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  254. Table:Objects5=O:O:0M::"Security Specs":Security
  255.  
  256. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  257. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  258. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  259.  
  260. Column:Category=Column
  261. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  262. Column:Attrs2=LENGTH="Physical Length"
  263. Column:Name=NAME
  264.  
  265. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  266. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  267. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  268. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  269. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  270. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  271.  
  272. Index:Category=Index
  273. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  274. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  275. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  276. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  277. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  278. Index:Attrs6=FORMAT="Format":2
  279. Index:Attrs7=BLOCKSIZE="Block Size":2
  280. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  281. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  282. Index:Attrs10=EXPRESSION="Expression":2:N
  283. Index:Attrs11=CONDITION="Subset Condition":2:N
  284. Index:Name=NAME
  285. Index:OnAfterLoad=GetIndexInfo
  286.  
  287. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  288. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  289. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  290. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  291.  
  292. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  293. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  294. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  295. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  296. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  297. ValCheck:Attrs6=PICTURE="Picture":2:N
  298. ValCheck:Name=FIELDNUM
  299.  
  300. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  301. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  302. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  303.  
  304. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  305. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  306. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  307. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  308. Reference:Name=NAME
  309. Reference:OnAfterLoad=GetReferenceInfo
  310.  
  311. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  312. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  313.  
  314. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  315. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  316. Security:Name=PASSWORD
  317.  
  318. [ODBC Properties]
  319. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  320. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  321. FieldVChecks:Values=Closed,0=,1="Has Validity Checks",2=
  322. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=
  323. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  324. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  325. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  326. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  327. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  328. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  329. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  330.  
  331. ODBC:Objects1=O:C:0M::"Tables":Table
  332. ODBC:Objects2=O:C:0M::"Procedures":Procedure
  333.  
  334. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  335. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  336. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  337. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  338. Table:Dataset5=PROTECTED=Word,VALID=Word
  339.  
  340. Table:Category=Dataset
  341. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  342. Table:Attrs2=DATE="Date"
  343. Table:Attrs3=TIME="Time"
  344. Table:Attrs4=VERSION="Version":2
  345. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  346. Table:Attrs6=STRUCTURE="Structure":2
  347. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  348. Table:Name=FILENAME,EXTENSION
  349. Table:Objects1=O:P:1M::"Fields":Column
  350. Table:Objects2=O:O:0M::"Indices":Index
  351. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  352. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  353. Table:Objects5=O:O:0M::"Security Specs":Security
  354.  
  355. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  356. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  357. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  358.  
  359. Column:Category=Column
  360. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  361. Column:Attrs2=LENGTH="Physical Length"
  362. Column:Name=NAME
  363.  
  364. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  365. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  366. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  367. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  368. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  369. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  370.  
  371. Index:Category=Index
  372. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  373. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  374. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  375. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  376. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  377. Index:Attrs6=FORMAT="Format":2
  378. Index:Attrs7=BLOCKSIZE="Block Size":2
  379. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  380. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  381. Index:Attrs10=EXPRESSION="Expression":2:N
  382. Index:Attrs11=CONDITION="Subset Condition":2:N
  383. Index:Name=NAME
  384. Index:OnAfterLoad=GetIndexInfo
  385.  
  386. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  387. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  388. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  389. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  390.  
  391. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  392. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  393. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  394. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  395. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  396. ValCheck:Attrs6=PICTURE="Picture":2:N
  397. ValCheck:Name=FIELDNUM
  398.  
  399. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  400. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  401. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  402.  
  403. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  404. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  405. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  406. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  407. Reference:Name=NAME
  408. Reference:OnAfterLoad=GetReferenceInfo
  409.  
  410. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  411. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  412.  
  413. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  414. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  415. Security:Name=PASSWORD
  416.  
  417. Procedure:Dataset=NAME=String,DATE=Date,TIME=Time
  418.  
  419. Procedure:Category=Executable
  420. Procedure:Attrs=DATE="Date":1,TIME="Time":1
  421. Procedure:EAttrs=Data
  422. Procedure:Name=NAME
  423.  
  424. [Oracle Properties]
  425. TBooleanNY:Values=Closed,N="No",Y="Yes"
  426. TBlank0:Values=Open,0=
  427. TValid:Values=Closed,INVALID=:"No",VALID=:"Yes"
  428. TDisabled:Values=Closed,ENABLED=ENABLE:,DISABLED=DISABLE:"Disabled"
  429. TDataType:Values1=Open,CHAR=`'CHAR('=Length')'`:CHAR
  430. TDataType:Values2=DATE=DATE
  431. TDataType:Values3=FLOAT=FLOAT
  432. TDataType:Values4=LONG=LONG
  433. TDataType:Values5=LONG RAW=LONG RAW
  434. TDataType:Values6=MLSLABEL=MLSLABEL
  435. TDataType:Values7=NUMBER=NUMBER
  436. TDataType:Values8=RAW=`'RAW('=Length')'`:RAW
  437. TDataType:Values9=ROWID=ROWID
  438. TDataType:Values10=VARCHAR2=`'VARCHAR2('=Length')'`:VARCHAR2
  439. TUnique:Values=Closed,NONUNIQUE=:"No",UNIQUE=UNIQUE:"Yes"
  440. TNulls:Values=Closed,N=NOT NULL:"No",Y=:"Yes"
  441. TMaxValue:Values=Open,=`'MAXVALUE ' @MaxValue`:`:MaxValue`,1E+27=NOMAXVALUE:"None"
  442. TMinValue:Values=Open,=`'MINVALUE ' @MinValue`:`:MinValue`,1E+27=NOMINVALUE:"None"
  443. TCycle:Values=Closed,N=NOCYCLE:"No",Y=CYCLE:"Yes"
  444. TOrder:Values=Closed,N=NOORDER:"No",Y=ORDER:"Yes"
  445. TCache:Values=Open,=`'CACHE ' @Cache`:`:Cache`,0=NOCACHE:"None"
  446. TTSStatus:Values1=Closed,ONLINE=ONLINE:"Online",OFFLINE=OFFLINE:"Offline"
  447. TTSStatus:Values2=READ ONLY=:"Read Only",INVALID=:"Invalid"
  448. TCluster:Values=Closed,INDEX=INDEX:"Index",HASH=HASH:"Hash"
  449. THashFn:Values1=Closed,COLUMN=:"Column",DEFAULT=:"Default",HASH EXPRESSION=:"Expression"
  450. THashFn:Values2=DEFAULT2=:"Default2"
  451. TRefresh:Values=Closed,FAST=FAST:"Fast",COMPLETE=COMPLETE:"Complete",FORCE=FORCE:"Force"
  452.  
  453. Template:Storage1=`! \N '    INITIAL ' =INITIAL_EXTENT`
  454. Template:Storage2=`! \N '    NEXT ' =NEXT_EXTENT`
  455. Template:Storage3=`! \N '    MINEXTENTS ' =MIN_EXTENTS`
  456. Template:Storage4=`! \N '    MAXEXTENTS ' =MAX_EXTENTS`
  457. Template:Storage5=`! \N '    PCTINCREASE ' =PCT_INCREASE`
  458.  
  459. Template:ObjectStorage=`ETemplates Storage`
  460.  
  461. Oracle:UserName=select user from dual
  462. Oracle:Comments=--;/*,*/
  463.  
  464. Oracle:Objects1=O:C:0M::"Tables":Table
  465. Oracle:Objects2=O:C:0M::"Views":View
  466. Oracle:Objects3=O:C:0M::"Synonyms":Synonym
  467. Oracle:Objects4=O:C:0M::"Snapshots":Snapshot
  468. Oracle:Objects5=O:C:0M::"Clusters":Cluster
  469. Oracle:Objects6=O:C:0M::"TableSpaces":TableSpace
  470. Oracle:Objects7=O:C:0M::"Sequences":Sequence
  471. Oracle:Objects8=O:C:0M::"Procedures":Procedure
  472. Oracle:Objects9=O:C:0M::"Functions":Function
  473. Oracle:Objects10=O:C:0M::"Packages":Package
  474. Oracle:Objects11=O:C:0M::"Package Bodies":PackageBody
  475.  
  476. SYS.ALL_OBJECTS:Name=OWNER,OBJECT_NAME
  477. SYS.ALL_OBJECTS:Attrs1=STATUS="Valid":::::VM=TValid
  478. SYS.ALL_OBJECTS:Attrs2=CREATED="Created"
  479. SYS.ALL_OBJECTS:Attrs3=LAST_DDL_TIME="Modified"
  480. SYS.ALL_OBJECTS:FilterSystemObjects=A.OWNER <> 'SYS'
  481.  
  482. SYS.ALL_TABLES:Name=OWNER,TABLE_NAME
  483. SYS.ALL_TABLES:Objects1=T:P:1M::"Columns":Column
  484. SYS.ALL_TABLES:Objects2=T:O:01::"Primary Key":PrimaryKey
  485. SYS.ALL_TABLES:Objects3=T:O:0M::"Indices":Index
  486. SYS.ALL_TABLES:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  487. SYS.ALL_TABLES:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  488. SYS.ALL_TABLES:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  489. SYS.ALL_TABLES:Objects7=T:O:0M::"Triggers":Trigger
  490. SYS.ALL_TABLES:Objects8=P:R:M1::"TableSpace":TableSpace
  491. SYS.ALL_TABLES:Objects9=P:R:M1::"Cluster":Cluster
  492. SYS.ALL_TABLES:Attrs1=BACKED_UP="Backed Up":::::VM=TBooleanNY
  493. SYS.ALL_TABLES:Attrs2=PCT_FREE="Block Min % Free":2:E
  494. SYS.ALL_TABLES:Attrs3=PCT_USED="Block Min % Used":2:E
  495. SYS.ALL_TABLES:Attrs4=INI_TRANS="Initial Transactions":2:E:::VM=TBlank0
  496. SYS.ALL_TABLES:Attrs5=MAX_TRANS="Maximum Transactions":2:E:::VM=TBlank0
  497. SYS.ALL_TABLES:Attrs6=INITIAL_EXTENT="Initial Extent (B)":2:E
  498. SYS.ALL_TABLES:Attrs7=NEXT_EXTENT="Next Extent (B)":2:E
  499. SYS.ALL_TABLES:Attrs8=MIN_EXTENTS="Min Extents":2:E
  500. SYS.ALL_TABLES:Attrs9=MAX_EXTENTS="Max Extents":2:E
  501. SYS.ALL_TABLES:Attrs10=PCT_INCREASE="Extent Size % Increase":2:E
  502. SYS.ALL_TABLES:Attrs11=NUM_ROWS="Row Count":2
  503. SYS.ALL_TABLES:Attrs12=CHAIN_CNT="Chained Rows":2
  504. SYS.ALL_TABLES:Attrs13=BLOCKS="Data Block Count":2
  505. SYS.ALL_TABLES:Attrs14=EMPTY_BLOCKS="Empty Data Blocks":2
  506. SYS.ALL_TABLES:Attrs15=AVG_SPACE="Avg Bytes Free / Block":2
  507. SYS.ALL_TABLES:Attrs16=AVG_ROW_LEN="Avg Row Length":2
  508. SYS.ALL_TABLES:Reference:"TableSpace"=TABLESPACE_NAME
  509. SYS.ALL_TABLES:Reference:"Cluster"=CLUSTER_NAME
  510. SYS.ALL_TABLES:FilterSystemObjects=A.OWNER <> 'SYS'
  511.  
  512. SYS.ALL_SYNONYMS:Name=OWNER,SYNONYM_NAME
  513. SYS.ALL_SYNONYMS:Attrs1=TABLE_OWNER="Target Owner"::E
  514. SYS.ALL_SYNONYMS:Attrs2=TABLE_NAME="Target Object"::ER
  515. SYS.ALL_SYNONYMS:Attrs3=DB_LINK="Database"::E
  516. SYS.ALL_SYNONYMS:Reference:"Target"=TABLE_OWNER,TABLE_NAME
  517.  
  518. SYS.ALL_SNAPSHOTS:Name=OWNER,NAME
  519. SYS.ALL_SNAPSHOTS:Objects=P:R:M1::"Snapshot Table":Table
  520. SYS.ALL_SNAPSHOTS:Attrs1=TYPE="Refresh Type"::E:::VM=TRefresh
  521. SYS.ALL_SNAPSHOTS:Attrs2=START_WITH="First Refresh"::E
  522. SYS.ALL_SNAPSHOTS:Attrs3=NEXT="Next Refresh"::E
  523. SYS.ALL_SNAPSHOTS:Attrs4=QUERY="Snapshot Query":2:ER
  524. SYS.ALL_SNAPSHOTS:Attrs5=ERROR="Error"
  525. SYS.ALL_SNAPSHOTS:Attrs6=LAST_REFRESH="Last Refresh"
  526. SYS.ALL_SNAPSHOTS:Attrs7=MASTER_LINK="Master Database":2
  527. SYS.ALL_SNAPSHOTS:Attrs8=MASTER_OWNER="Master Owner":2
  528. SYS.ALL_SNAPSHOTS:Attrs9=MASTER_VIEW="Master View":2
  529. SYS.ALL_SNAPSHOTS:Attrs10=MASTER="Master Table":2
  530. SYS.ALL_SNAPSHOTS:Attrs11=UPDATABLE="Updatable":2
  531. SYS.ALL_SNAPSHOTS:Attrs12=CAN_USE_LOG="Snapshot Log":2
  532. SYS.ALL_SNAPSHOTS:Reference:"Snapshot Table"=OWNER,TABLE_NAME
  533.  
  534. SYS.ALL_INDEXES:Key=TABLE_OWNER,TABLE_NAME,OWNER,INDEX_NAME
  535. SYS.ALL_INDEXES:Name=OWNER,INDEX_NAME
  536. SYS.ALL_INDEXES:Objects1=T:P:1M::"Columns":IndexColumn
  537. SYS.ALL_INDEXES:Objects2=P:R:M1::"TableSpace":TableSpace
  538. SYS.ALL_INDEXES:Attrs1=STATUS="Valid":::::VM=TValid
  539. SYS.ALL_INDEXES:Attrs2=UNIQUENESS="Unique"::E:::VM=TUnique
  540. SYS.ALL_INDEXES:Attrs3=INITIAL_EXTENT="Initial Extent (B)":2:E
  541. SYS.ALL_INDEXES:Attrs4=NEXT_EXTENT="Other Extents (B)":2:E
  542. SYS.ALL_INDEXES:Attrs5=MIN_EXTENTS="Minimum Extents":2:E
  543. SYS.ALL_INDEXES:Attrs6=MAX_EXTENTS="Maximum Extents":2:E
  544. SYS.ALL_INDEXES:Attrs7=PCT_INCREASE="% Increase":2:E
  545. SYS.ALL_INDEXES:Attrs8=PCT_FREE="Minimum % Free":2:E
  546. SYS.ALL_INDEXES:Attrs9=INI_TRANS="Initial Transactions":2:E:::VM=TBlank0
  547. SYS.ALL_INDEXES:Attrs10=MAX_TRANS="Maximum Transactions":2:E:::VM=TBlank0
  548. SYS.ALL_INDEXES:Reference:"TableSpace"=TABLESPACE_NAME
  549.  
  550. SYS.ALL_IND_COLUMNS:Key=TABLE_OWNER,TABLE_NAME,INDEX_OWNER,INDEX_NAME,COLUMN_NAME
  551. SYS.ALL_IND_COLUMNS:Name=Column
  552. SYS.ALL_IND_COLUMNS:Order=COLUMN_POSITION
  553. SYS.ALL_IND_COLUMNS:Objects1=P:R:M1::"Column":Column:<<>Column
  554. SYS.ALL_IND_COLUMNS:Attrs1=COLUMN_POSITION="Order":2:ER
  555. SYS.ALL_IND_COLUMNS:Reference:"Column"=TABLE_OWNER,TABLE_NAME,COLUMN_NAME
  556. ; TODO: ASC/DESC information is lost in system catalog
  557.  
  558. SYS.ALL_TAB_COLUMNS:Key=OWNER,TABLE_NAME,COLUMN_NAME
  559. SYS.ALL_TAB_COLUMNS:Name=COLUMN_NAME
  560. SYS.ALL_TAB_COLUMNS:Order=COLUMN_ID
  561. SYS.ALL_TAB_COLUMNS:Attrs1=COLUMN_ID="Order":2:ER
  562. SYS.ALL_TAB_COLUMNS:Attrs2=DATA_TYPE=Type="Type"::ER:::VM=TDataType
  563. SYS.ALL_TAB_COLUMNS:Attrs3=DATA_LENGTH=Length="Length"::E
  564. SYS.ALL_TAB_COLUMNS:Attrs4=DATA_PRECISION=Precision="Precision"::E
  565. SYS.ALL_TAB_COLUMNS:Attrs5=DATA_SCALE=Scale="Scale"::E
  566. SYS.ALL_TAB_COLUMNS:Attrs6=NULLABLE=Null="Nulls"::E:::VM=TNulls
  567. SYS.ALL_TAB_COLUMNS:Attrs7=DATA_DEFAULT=Default="Default":2:E
  568.  
  569. SYS.ALL_SEQUENCES:Name=SEQUENCE_OWNER,SEQUENCE_NAME
  570. SYS.ALL_SEQUENCES:Attrs1=LAST_NUMBER="Last Value"::E
  571. SYS.ALL_SEQUENCES:Attrs2=INCREMENT_BY="Increment By"::E
  572. SYS.ALL_SEQUENCES:Attrs3=CYCLE_FLAG=Cycle="Cycle"::E:::VM=TCycle
  573. SYS.ALL_SEQUENCES:Attrs4=ORDER_FLAG=Order="In Order"::E:::VM=TOrder
  574. SYS.ALL_SEQUENCES:Attrs5=MIN_VALUE=MinValue="Minimum Value":2:E:::VM=TMinValue
  575. SYS.ALL_SEQUENCES:Attrs6=MAX_VALUE=MaxValue="Maximum Value":2:E:::VM=TMaxValue
  576. SYS.ALL_SEQUENCES:Attrs7=CACHE_SIZE=Cache="Cache Size":2:E:::VM=TCache
  577.  
  578. SYS.ALL_TRIGGERS:Key=TABLE_OWNER,TABLE_NAME,OWNER,TRIGGER_NAME
  579. SYS.ALL_TRIGGERS:Name=OWNER,TRIGGER_NAME
  580. SYS.ALL_TRIGGERS:Objects=P:R:M1::"Table":Table
  581. SYS.ALL_TRIGGERS:Attrs1=TRIGGERING_EVENT="Event",TRIGGER_TYPE="Type"
  582. SYS.ALL_TRIGGERS:Attrs2=REFERENCING_NAMES="Referencing Names":2
  583. SYS.ALL_TRIGGERS:Attrs3=WHEN_CLAUSE="When":2,DESCRIPTION="Description":2
  584. SYS.ALL_TRIGGERS:Attrs4=TRIGGER_BODY="Text":3
  585.  
  586. SYS.ALL_CONSTRAINTS:Key=OWNER,TABLE_NAME,CONSTRAINT_NAME
  587. SYS.ALL_CONSTRAINTS:Name=CONSTRAINT_NAME
  588. SYS.ALL_CONSTRAINTS:Attrs1=STATUS="Disabled"::E:::VM=TDisabled
  589.  
  590. SYS.ALL_CONS_COLUMNS:Key=OWNER,TABLE_NAME,CONSTRAINT_NAME,COLUMN_NAME
  591. SYS.ALL_CONS_COLUMNS:Name=Column
  592. SYS.ALL_CONS_COLUMNS:Order=POSITION
  593. SYS.ALL_CONS_COLUMNS:Objects1=P:R:M1::"Column":Column:<<>Column
  594. SYS.ALL_CONS_COLUMNS:Attrs1=POSITION="Order":2:ER
  595. SYS.ALL_CONS_COLUMNS:Reference:"Column"=OWNER,TABLE_NAME,COLUMN_NAME
  596.  
  597. SYS.SYSFILES:Key=TSNAME,FNAME
  598. SYS.SYSFILES:Name=FNAME
  599. SYS.SYSFILES:Attrs=FNAME=:3,BLOCKS="Blocks"
  600.  
  601. SYS.USER_CLUSTERS:Name=CLUSTER_NAME
  602. SYS.USER_CLUSTERS:Objects1=T:P:1M::"Columns":ClusterColumn
  603. SYS.USER_CLUSTERS:Objects2=P:R:M1::"TableSpace":TableSpace
  604. SYS.USER_CLUSTERS:Attrs1=CLUSTER_TYPE="Type":::::VM=TCluster
  605. SYS.USER_CLUSTERS:Attrs2=FUNCTION="Hash Fn":::::VM=THashFn
  606. SYS.USER_CLUSTERS:Attrs3=PCT_FREE="Block Min % Free":2
  607. SYS.USER_CLUSTERS:Attrs4=PCT_USED="Block Min % Used":2
  608. SYS.USER_CLUSTERS:Attrs5=INI_TRANS="Initial Transactions":2::::VM=TBlank0
  609. SYS.USER_CLUSTERS:Attrs6=MAX_TRANS="Maximum Transactions":2::::VM=TBlank0
  610. SYS.USER_CLUSTERS:Attrs7=INITIAL_EXTENT="Initial Extent (B)":2
  611. SYS.USER_CLUSTERS:Attrs8=NEXT_EXTENT="Other Extents (B)":2
  612. SYS.USER_CLUSTERS:Attrs9=MIN_EXTENTS="Minimum Extents":2
  613. SYS.USER_CLUSTERS:Attrs10=MAX_EXTENTS="Maximum Extents":2
  614. SYS.USER_CLUSTERS:Attrs11=PCT_INCREASE="Extent Size % Increase":2
  615. SYS.USER_CLUSTERS:Attrs12=KEY_SIZE="Key Size":2
  616. SYS.USER_CLUSTERS:Attrs13=HASHKEYS="Hash Keys":2
  617. SYS.USER_CLUSTERS:Attrs14=AVG_BLOCKS_PER_KEY="Blocks / Key":2
  618. SYS.USER_CLUSTERS:Reference:"TableSpace"=TABLESPACE_NAME
  619.  
  620. SYS.USER_CLU_COLUMNS:Key=CLUSTER_NAME,CLU_COLUMN_NAME
  621. SYS.USER_CLU_COLUMNS:Name=CLU_COLUMN_NAME
  622. SYS.USER_CLU_COLUMNS:Attrs1=TABLE_NAME="Table"
  623. SYS.USER_CLU_COLUMNS:Attrs2=TAB_COLUMN_NAME="Column"
  624.  
  625. SYS.USER_TABLESPACES:Name=TABLESPACE_NAME
  626. SYS.USER_TABLESPACES:Attrs1=STATUS="Status":::::VM=TTSStatus
  627. SYS.USER_TABLESPACES:Attrs2=INITIAL_EXTENT="Initial Extent (B)":2:E
  628. SYS.USER_TABLESPACES:Attrs3=NEXT_EXTENT="Other Extents (B)":2:E
  629. SYS.USER_TABLESPACES:Attrs4=MIN_EXTENTS="Minimum Extents":2:E
  630. SYS.USER_TABLESPACES:Attrs5=MAX_EXTENTS="Maximum Extents":2:E
  631. SYS.USER_TABLESPACES:Attrs6=PCT_INCREASE="% Increase":2:E
  632.  
  633. CheckConstraint:Definition=Root=SYS.ALL_CONSTRAINTS
  634. CheckConstraint:Category=Expression
  635. CheckConstraint:Values=A.CONSTRAINT_TYPE = 'C'
  636. CheckConstraint:Objects=T:P:0M::"Columns":ConstraintColumn
  637. CheckConstraint:Attrs1=SEARCH_CONDITION=Text="Text":3:ER
  638. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  639. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N`  ADD CONSTRAINT CheckConstraint1 `\N`  CHECK ()
  640. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N` `\N`  CHECK (`=Text`)
  641. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_+\((.*)\)
  642. CheckConstraint:Text:Set=1=`{<}N`,Text=3,*N=2
  643. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  644.  
  645. Cluster:Definition=Root=SYS.USER_CLUSTERS
  646. Cluster:EAttrs=
  647.  
  648. ClusterColumn:Definition=Root=SYS.USER_CLU_COLUMNS
  649. ClusterColumn:EAttrs=
  650.  
  651. Column:Definition=Root=SYS.ALL_TAB_COLUMNS
  652. Column:Category=Column
  653. Column:EAttrs=Text,New,Delete,Modify,Rename
  654. Column:Text:Get=`N ' ' EType``! ' DEFAULT ' =Default``! ' ' =Null`
  655.  
  656. ConstraintColumn:Definition=Root=SYS.ALL_CONS_COLUMNS
  657. ConstraintColumn:Category=ColumnReference
  658. ConstraintColumn:Attrs:R=Column:::2:ER
  659. ConstraintColumn:EAttrs=Text,New,Delete,Modify,Rename
  660. ConstraintColumn:Text:Get=`N`
  661.  
  662. ForeignKey:Definition=Root=SYS.ALL_CONSTRAINTS
  663. ForeignKey:Category=ForeignKey
  664. ForeignKey:Values=A.CONSTRAINT_TYPE = 'R'
  665. ForeignKey:Objects1=T:P:1M::"Columns":ConstraintColumn
  666. ForeignKey:Objects2=P:R:M1::"Reference Table":Table
  667. ForeignKey:Attrs=DELETE_RULE="Delete Rule":2
  668. ForeignKey:Attrs:Q=ReferenceTable=String:::0
  669. ForeignKey:Attrs:R=Table::::ER
  670. ForeignKey:AttrReference:ReferenceTable1=SELECT TABLE_NAME FROM SYS.ALL_CONSTRAINTS
  671. ForeignKey:AttrReference:ReferenceTable2=WHERE CONSTRAINT_TYPE = 'P'
  672. ForeignKey:AttrReference:ReferenceTable3=AND OWNER = `:R_OWNER`
  673. ForeignKey:AttrReference:ReferenceTable4=AND CONSTRAINT_NAME = `:R_CONSTRAINT_NAME`
  674. ForeignKey:Reference:"Reference Table"=R_OWNER,ReferenceTable
  675. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  676. ForeignKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `N`
  677. ForeignKey:Text:Get2=`\N`  FOREIGN KEY `'(' [ConstraintColumn:%s, %s:N] ')'`
  678. ForeignKey:Text:Get3=`\N`  REFERENCES `=Table`
  679. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  680.  
  681. Parameter:Definition=Root=SYS.ALL_TAB_COLUMNS
  682. Parameter:Category=Column
  683. Parameter:EAttrs=Text
  684. Parameter:Text:Get=`N`
  685.  
  686. Function:Definition=Root=SYS.ALL_OBJECTS
  687. Function:Category=Executable
  688. Function:Values=A.OBJECT_TYPE = 'FUNCTION'
  689. Function:Objects=T:P:0M::"Parameters":Parameter
  690. Function:Attrs:Q=Text=Memo::"Text"::ER
  691. Function:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  692. Function:AttrReference:Text2=where OWNER='`O0`' and NAME='`O1`'
  693. Function:AttrReference:Text3=order by LINE
  694. Function:Warning=Loss
  695. Function:EAttrs=Text,New,Delete,Modify,Rename,Save
  696. Function:Text:Get=CREATE `=Text`
  697. Function:Text:Init1=CREATE FUNCTION Function1
  698. Function:Text:Init2=RETURN datatype AS `\N`BEGIN`\N`END;
  699. Function:Text:NameRE=Text:FUNCTION\_(\_*\w+)
  700. Function:Text:NameSet=1=`N`
  701. Function:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(FUNCTION\_+(\w+)\_.*)
  702. Function:Text:Set=1=`''`,Text=2,*N=3
  703. Function:Modify:RE=(CREATE)\_+FUNCTION
  704. Function:Modify:Set=1=`'CREATE OR REPLACE'`
  705. Function:Delete:Text=DROP FUNCTION `O`
  706. Function:Actions="Compile"
  707. Function:"Compile":Text=ALTER FUNCTION `N` COMPILE
  708.  
  709. Index:Definition=Root=SYS.ALL_INDEXES
  710. Index:Category=Index
  711. Index:Attrs:R=TableSpace::INITIAL_EXTENT:2:E
  712. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  713. Index:Text:Get1=CREATE `=UNIQUENESS` INDEX `N`
  714. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:N]`)
  715. Index:Text:Get3=`! \N '  TABLESPACE ' =TableSpace`
  716. Index:Text:Get4=`! \N '  PCTFREE ' =PCT_FREE`
  717. Index:Text:Get5=`! \N '  INITRANS ' =INI_TRANS`
  718. Index:Text:Get6=`! \N '  MAXTRANS ' =MAX_TRANS`
  719. Index:Text:Get7=`! \N '  STORAGE (' ETemplates ObjectStorage ')'`
  720. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  721. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  722. Index:Delete:Text=DROP INDEX `O`
  723.  
  724. IndexColumn:Definition=Root=SYS.ALL_IND_COLUMNS
  725. IndexColumn:Category=ColumnReference
  726. IndexColumn:Attrs:R=Column:::2:ER
  727. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  728. IndexColumn:Text:Get=`N`
  729.  
  730. Package:Definition=Root=SYS.ALL_OBJECTS
  731. Package:Values=A.OBJECT_TYPE = 'PACKAGE'
  732. Package:Objects=P:R:M0::"Package Body":PackageBody
  733. Package:Attrs:Q=Text=Memo::"Text"::ER
  734. Package:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  735. Package:AttrReference:Text2=where OWNER='`O0`' and NAME='`O1`'
  736. Package:AttrReference:Text3=and TYPE=`:OBJECT_TYPE` order by LINE
  737. Package:Warning=Loss
  738. Package:EAttrs=Text,New,Delete,Modify,Rename,Save
  739. Package:Text:Get=CREATE `=Text`
  740. Package:Text:Init=CREATE PACKAGE Package1 AS `\N`BEGIN`\N`END
  741. Package:Text:NameRE=Text:PACKAGE\_(\_*\w+)
  742. Package:Text:NameSet=1=`N`
  743. Package:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(PACKAGE\_+(\w+)\_.*)
  744. Package:Text:Set=1=`''`,Text=2,*N=3
  745. Package:Modify:RE=(CREATE)\_+PACKAGE
  746. Package:Modify:Set=1=`'CREATE OR REPLACE'`
  747. Package:Delete:Text=DROP PACKAGE `O`
  748. Package:Actions="Compile","Compile All":';'
  749. Package:"Compile All":Text1=ALTER PACKAGE `N` COMPILE PACKAGE;
  750. Package:"Compile All":Text2=ALTER PACKAGE `N` COMPILE BODY
  751. Package:"Compile":Text=ALTER PACKAGE `N` COMPILE PACKAGE
  752.  
  753. PackageBody:Definition=Root=SYS.ALL_OBJECTS
  754. PackageBody:Values=A.OBJECT_TYPE = 'PACKAGE BODY'
  755. PackageBody:Objects=P:R:M0::"Package":Package
  756. PackageBody:Attrs:Q=Text=Memo::"Text"::ER
  757. PackageBody:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  758. PackageBody:AttrReference:Text2=where OWNER='`O0`' and NAME='`O1`'
  759. PackageBody:AttrReference:Text3=and TYPE=`:OBJECT_TYPE` order by LINE
  760. PackageBody:Warning=Loss
  761. PackageBody:EAttrs=Text,New,Delete,Modify,Rename,Save
  762. PackageBody:Text:Get=CREATE `=Text`
  763. PackageBody:Text:Init=CREATE PACKAGE BODY PackageBody1 AS `\N`BEGIN`\N`END
  764. PackageBody:Text:NameRE=Text:PACKAGE\_+BODY\_(\_*\w+)
  765. PackageBody:Text:NameSet=1=`N`
  766. PackageBody:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(PACKAGE\_+BODY\_+(\w+)\_.*)
  767. PackageBody:Text:Set=1=`''`,Text=2,*N=3
  768. PackageBody:Modify:RE=(CREATE)\_+PACKAGE\_+BODY
  769. PackageBody:Modify:Set=1=`'CREATE OR REPLACE'`
  770. PackageBody:Delete:Text=DROP PACKAGE BODY `O`
  771. PackageBody:Actions="Compile"
  772. PackageBody:"Compile":Text=ALTER PACKAGE `N` COMPILE BODY
  773.  
  774. PrimaryKey:Definition=Root=SYS.ALL_CONSTRAINTS
  775. PrimaryKey:Category=PrimaryKey
  776. PrimaryKey:Values=A.CONSTRAINT_TYPE = 'P'
  777. PrimaryKey:Objects=T:P:1M::"Columns":ConstraintColumn
  778. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  779. PrimaryKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `N`
  780. PrimaryKey:Text:Get2=`\N`  PRIMARY KEY `'(' [ConstraintColumn:%s, %s:N] ')'`
  781. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  782.  
  783. Procedure:Definition=Root=SYS.ALL_OBJECTS
  784. Procedure:Category=Executable
  785. Procedure:Values=A.OBJECT_TYPE = 'PROCEDURE'
  786. Procedure:Objects=T:P:0M::"Parameters":Parameter
  787. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  788. Procedure:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  789. Procedure:AttrReference:Text2=where OWNER='`O0`' and NAME='`O1`'
  790. Procedure:AttrReference:Text3=order by LINE
  791. Procedure:Warning=Loss
  792. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  793. Procedure:Text:Get=CREATE `=Text`
  794. Procedure:Text:Init=CREATE PROCEDURE Procedure1 AS `\N`BEGIN`\N`END;
  795. Procedure:Text:NameRE=Text:PROCEDURE\_(\_*\w+)
  796. Procedure:Text:NameSet=1=`N`
  797. Procedure:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(PROCEDURE\_+(\w+)\_.*)
  798. Procedure:Text:Set=1=`''`,Text=2,*N=3
  799. Procedure:Modify:RE=(CREATE)\_+PROCEDURE
  800. Procedure:Modify:Set=1=`'CREATE OR REPLACE'`
  801. Procedure:Delete:Text=DROP PROCEDURE `O`
  802. Procedure:Actions="Compile"
  803. Procedure:"Compile":Text=ALTER PROCEDURE `N` COMPILE
  804.  
  805. Sequence:Definition=Root=SYS.ALL_SEQUENCES
  806. Sequence:Attrs:T1=SYS.ALL_OBJECTS.STATUS=::LAST_NUMBER
  807. Sequence:Attrs:T2=SYS.ALL_OBJECTS.CREATED=::LAST_NUMBER
  808. Sequence:Attrs:T3=SYS.ALL_OBJECTS.LAST_DDL_TIME=::LAST_NUMBER
  809. Sequence:Warning=Loss
  810. Sequence:EAttrs=Text,New,Delete,Modify,Rename,Save
  811. Sequence:Text:Get1=CREATE SEQUENCE `N`
  812. Sequence:Text:Get2=`! \N '  START WITH ' =LAST_NUMBER`
  813. Sequence:Text:Get3=`! \N '  INCREMENT BY ' =INCREMENT_BY`
  814. Sequence:Text:Get4=`! \N '  ' =MaxValue`
  815. Sequence:Text:Get5=`! \N '  ' =MinValue`
  816. Sequence:Text:Get6=`! \N '  ' =Cycle`
  817. Sequence:Text:Get7=`! \N '  ' =Cache`
  818. Sequence:Text:Get8=`! \N '  ' =Order`
  819. Sequence:Delete:Text=DROP SEQUENCE `O`
  820.  
  821. Snapshot:Definition=Root=SYS.ALL_SNAPSHOTS
  822. Snapshot:Warning=DataLoss
  823. Snapshot:EAttrs=Text,New,Delete,Modify,Rename,Save
  824. Snapshot:Text:Get1=CREATE SNAPSHOT `N` `! 'REFRESH ' =TYPE`
  825. Snapshot:Text:Get2=`! 'START WITH ' =START_WITH` `! 'NEXT ' =NEXT`
  826. Snapshot:Text:Get3=`\N`AS `=QUERY`
  827. Snapshot:Delete:Text=DROP SNAPSHOT `O`
  828.  
  829. Synonym:Definition=Root=SYS.ALL_SYNONYMS
  830. Synonym:Category=Dataset
  831. Synonym:Attrs:T1=SYS.ALL_OBJECTS.STATUS=::TABLE_OWNER
  832. Synonym:Attrs:T2=SYS.ALL_OBJECTS.CREATED=::TABLE_OWNER
  833. Synonym:Attrs:T3=SYS.ALL_OBJECTS.LAST_DDL_TIME=::TABLE_OWNER
  834. Synonym:Warning=Loss
  835. Synonym:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  836. Synonym:Text:Init=CREATE SYNONYM Synonym1 FOR "owner"."object"
  837. Synonym:Text:Get1=CREATE SYNONYM `N`
  838. Synonym:Text:Get2=`\N`FOR "`=TABLE_OWNER`"."`=TABLE_NAME`"
  839. Synonym:Delete:Text=DROP SYNONYM `O`
  840.  
  841. Table:Definition=Root=SYS.ALL_TABLES
  842. Table:Category=Dataset
  843. Table:Attrs:T1=SYS.ALL_OBJECTS.STATUS=::BACKED_UP
  844. Table:Attrs:T2=SYS.ALL_OBJECTS.CREATED=::BACKED_UP
  845. Table:Attrs:T3=SYS.ALL_OBJECTS.LAST_DDL_TIME=::BACKED_UP
  846. Table:Attrs:R1=TableSpace::PCT_FREE:2:E
  847. Table:Attrs:R2=Cluster::PCT_FREE:2:E
  848. Table:Warning=DataLoss
  849. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  850. Table:Text:Get1=CREATE TABLE `N` (`[Column:%s,%s:\N '  ' *] \N`)
  851. Table:Text:Get2=`! \N '  TABLESPACE ' =TableSpace`
  852. Table:Text:Get3=`! \N '  PCTFREE ' =PCT_FREE`
  853. Table:Text:Get4=`! \N '  PCTUSED ' =PCT_USED`
  854. Table:Text:Get5=`! \N '  INITRANS ' =INI_TRANS`
  855. Table:Text:Get6=`! \N '  MAXTRANS ' =MAX_TRANS`
  856. Table:Text:Get7=`! \N '  STORAGE (' ETemplates ObjectStorage ')'`
  857. Table:Rename:Text=RENAME "`O1`" TO "`N1`"
  858. Table:Delete:Text=DROP TABLE `O`
  859.  
  860. Trigger:Definition=Root=SYS.ALL_TRIGGERS
  861. Trigger:Category=Executable
  862. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  863. Trigger:Text:Init=CREATE TRIGGER Trigger1 ON `{<}N` AS `\N`BEGIN`\N`END;
  864. Trigger:Text:Get=`="Text"`
  865. Trigger:Text:NameRE=Text:TRIGGER\_(\_*\w+)\_.*ON\_(\_*\w+)
  866. Trigger:Text:NameSet=1=`N`,2=`{<}N`
  867. Trigger:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(TRIGGER\_+(\w+)\_.*\_ON\_(\_*\w+).*)
  868. Trigger:Text:Set=1=`''`,Text=2,*N=3,4=`{<}N`
  869.  
  870. UniqueConstraint:Definition=Root=SYS.ALL_CONSTRAINTS
  871. UniqueConstraint:Category=UniqueConstraint
  872. UniqueConstraint:Values=A.CONSTRAINT_TYPE = 'U'
  873. UniqueConstraint:Objects=T:P:1M::"Columns":ConstraintColumn
  874. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  875. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  876. UniqueConstraint:Text:Get2=`\N`  UNIQUE `'(' [ConstraintColumn:%s, %s:N] ')'`
  877. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  878.  
  879. View:Definition=Root=SYS.ALL_OBJECTS
  880. View:Category=Dataset
  881. View:Values=A.OBJECT_TYPE = 'VIEW'
  882. View:Objects=T:P:0M:NMDR:"Columns":Column
  883. View:Attrs:Q=Text=Memo::"Text"::ER
  884. View:AttrReference:Text1=select TEXT from SYS.ALL_VIEWS
  885. View:AttrReference:Text2=where OWNER='`O0`' and VIEW_NAME='`O1`'
  886. View:Warning=Loss
  887. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  888. View:Text:Init=CREATE VIEW View1 AS `\N`  SELECT * FROM "owner"."object"
  889. View:Text:Get=CREATE VIEW `N` AS `\N '  ' =Text`
  890. View:Text:RE=CREATE\_+VIEW\_+(\w+)\_+AS\_+(.*)
  891. View:Text:Set=Text=2,*N=1
  892. View:Rename:Text=RENAME "`O1`" TO "`N1`"
  893. View:Delete:Text=DROP VIEW `O`
  894.  
  895. TableSpace:Definition=Root=SYS.USER_TABLESPACES
  896. TableSpace:Objects=T:C:1M::"Files":File
  897. TableSpace:Reference:"Files":Text=`[File:%s,%s:\N '    ' \Q * \Q]`
  898. TableSpace:Warning=Loss
  899. TableSpace:EAttrs=Text
  900. TableSpace:Text:Get1=CREATE TABLESPACE `N \N`
  901. TableSpace:Text:Get2= DATAFILE `{>File}*\N`
  902. TableSpace:Text:Get3=`! ' DEFAULT STORAGE (' ETemplates Storage ')' \N`
  903. TableSpace:Text:Get9=`! ' ' =STATUS \N`
  904. TableSpace:Delete:Text=DROP TABLESPACE `O`
  905.  
  906. File:Definition=Root=SYS.SYSFILES
  907. File:Category=System
  908. File:NameRE=.*
  909. File:EAttrs=Text
  910. File:Text:Get=`N`
  911.  
  912. [Oracle 7.2 Properties]
  913.  
  914. SYS.ALL_CLUSTERS:Name=OWNER,CLUSTER_NAME
  915. SYS.ALL_CLUSTERS:Objects1=T:P:1M::"Columns":ClusterColumn
  916. SYS.ALL_CLUSTERS:Objects1=P:R:M1::"TableSpace":TableSpace
  917. SYS.ALL_CLUSTERS:Attrs1=CLUSTER_TYPE="Type":::::VM=TCluster
  918. SYS.ALL_CLUSTERS:Attrs2=FUNCTION="Hash Fn":::::VM=THashFn
  919. SYS.ALL_CLUSTERS:Attrs3=PCT_FREE="Block Min % Free":2
  920. SYS.ALL_CLUSTERS:Attrs4=PCT_USED="Block Min % Used":2
  921. SYS.ALL_CLUSTERS:Attrs5=INI_TRANS="Initial Transactions":2::::VM=TBlank0
  922. SYS.ALL_CLUSTERS:Attrs6=MAX_TRANS="Maximum Transactions":2::::VM=TBlank0
  923. SYS.ALL_CLUSTERS:Attrs7=INITIAL_EXTENT="Initial Extent (B)":2
  924. SYS.ALL_CLUSTERS:Attrs8=NEXT_EXTENT="Other Extents (B)":2
  925. SYS.ALL_CLUSTERS:Attrs9=MIN_EXTENTS="Minimum Extents":2
  926. SYS.ALL_CLUSTERS:Attrs10=MAX_EXTENTS="Maximum Extents":2
  927. SYS.ALL_CLUSTERS:Attrs11=PCT_INCREASE="Extent Size % Increase":2
  928. SYS.ALL_CLUSTERS:Attrs12=KEY_SIZE="Key Size":2
  929. SYS.ALL_CLUSTERS:Attrs13=HASHKEYS="Hash Keys":2
  930. SYS.ALL_CLUSTERS:Attrs14=AVG_BLOCKS_PER_KEY="Blocks / Key":2
  931. SYS.ALL_CLUSTERS:Reference:"ClusterColumn"=CLUSTER_NAME
  932. SYS.ALL_CLUSTERS:Reference:"TableSpace"=TABLESPACE_NAME
  933.  
  934. ; Add FREELISTS and FREELIST_GROUPS for Oracle 7.2+
  935.  
  936. Template:ObjectStorage1=`ETemplates Storage`
  937. Template:ObjectStorage2=`! \N '    FREELISTS ' =FREELISTS`
  938. Template:ObjectStorage3=`! \N '    FREELIST GROUPS ' =FREELIST_GROUPS`
  939.  
  940. SYS.ALL_TABLES:Attrs1=BACKED_UP="Backed Up":::::VM=TBooleanNY
  941. SYS.ALL_TABLES:Attrs2=PCT_FREE="Block Min % Free":2:E
  942. SYS.ALL_TABLES:Attrs3=PCT_USED="Block Min % Used":2:E
  943. SYS.ALL_TABLES:Attrs4=INI_TRANS="Initial Transactions":2:E:::VM=TBlank0
  944. SYS.ALL_TABLES:Attrs5=MAX_TRANS="Maximum Transactions":2:E:::VM=TBlank0
  945. SYS.ALL_TABLES:Attrs6=INITIAL_EXTENT="Initial Extent (B)":2:E
  946. SYS.ALL_TABLES:Attrs7=NEXT_EXTENT="Next Extent (B)":2:E
  947. SYS.ALL_TABLES:Attrs8=MIN_EXTENTS="Min Extents":2:E
  948. SYS.ALL_TABLES:Attrs9=MAX_EXTENTS="Max Extents":2:E
  949. SYS.ALL_TABLES:Attrs10=PCT_INCREASE="Extent Size % Increase":2:E
  950. SYS.ALL_TABLES:Attrs11=FREELISTS="Free Lists":2:E
  951. SYS.ALL_TABLES:Attrs12=FREELIST_GROUPS="Free List Groups":2:E
  952. SYS.ALL_TABLES:Attrs13=NUM_ROWS="Row Count":2
  953. SYS.ALL_TABLES:Attrs14=CHAIN_CNT="Chained Rows":2
  954. SYS.ALL_TABLES:Attrs15=BLOCKS="Data Block Count":2
  955. SYS.ALL_TABLES:Attrs16=EMPTY_BLOCKS="Empty Data Blocks":2
  956. SYS.ALL_TABLES:Attrs17=AVG_SPACE="Avg Bytes Free / Block":2
  957. SYS.ALL_TABLES:Attrs18=AVG_ROW_LEN="Avg Row Length":2
  958.  
  959. ; TODO: Use ALL_CLUSTERS instead of USER_CLUSTERS for 7.2+
  960. ; Need DBA_CLU_COLUMNS (or ALL_CLU_COLUMNS) owner to fully qualify
  961. ; which is not defined in 7.2
  962. ; Cluster:Definition=Root=SYS.ALL_CLUSTERS
  963. ; SYS.ALL_TABLES:Reference:"Cluster"=OWNER,CLUSTER_NAME
  964.  
  965.  
  966. [MSSQL Properties]
  967. TBooleanYN:Values=Closed,0="No",-1="Yes"
  968. TPhysicalType:Values1=Closed,34=image:"Image",35=text:"Text"
  969. TPhysicalType:Values2=37=`'varbinary'``!'('=Length')'`:"VarBinary"
  970. TPhysicalType:Values3=38=int:"Int"
  971. TPhysicalType:Values4=39=`'varchar'``!'('=Length')'`:"VarChar"
  972. TPhysicalType:Values5=45=`'binary'``!'('=Length')'`:"Binary"
  973. TPhysicalType:Values6=47=`'char'``!'('=Length')'`:"Char"
  974. TPhysicalType:Values7=48=tinyint:"TinyInt",50=bit:"Bit"
  975. TPhysicalType:Values8=52=smallint:"SmallInt",55=decimal:"Decimal",56=int:"Int"
  976. TPhysicalType:Values9=58=smalldatetime:"SmallDateTime",59=real:"Real"
  977. TPhysicalType:Values10=60=money:"Money",61=datetime:"DateTime",62=float:"Float"
  978. TPhysicalType:Values11=63=numeric:"Numeric",106=decimal:"Decimal"
  979. TPhysicalType:Values12=108=numeric:"Numeric",109=float:"Float",110=money:"Money"
  980. TPhysicalType:Values13=111=datetime:"DateTime",122=smallmoney:"SmallMoney"
  981. TNull01:Values=Closed,0=not null:"No",-1=null:"Yes"
  982. TObjectType:Values1=Closed,S="System Table",U="Table",V="View",L="Log",P="Procedure",
  983. TObjectType:Values2=R="Rule",D="Default",TR="Trigger",RI="Referential Constraint"
  984. TObjectStatus:Values=Closed,256="Read Only",4096="RamboIX"
  985. TColumnStatus:Values=Closed,8=NULL:"Null"
  986. TIndexStatus:Values1=Closed,2=UNIQUE:"Unique",16=CLUSTERED:"Clustered"
  987. TIndexStatus:Values2=1=:"Dup Key Abort",4=:"Dup Row Abort"
  988. TIndexStatus:Values3=64=:"Allow Dup Rows",32768=:"Suspect"
  989. TLoginStatus:Values=Closed,1=:"Small Password",2=:"Locked account",4=:"Password Expired"
  990. TDeviceType:Values1=Closed,0=0:"Database",2=2:"Disk Dump",3=3:"Tape Dump",4=4:"Tape Dump"
  991. TDeviceType:Values2=5=5:"Tape Dump",6=6:"Tape Dump",7=7:"Tape Dump",8=8:"Tape Dump"
  992. TDeviceStatus:Values1=Closed,1=:"Default",2=:"Physical Disk",4=:"Logical Disk"
  993. TDeviceStatus:Values2=8=:"Skip Header",16=:"Dump Device",32=:"Serial Writes"
  994. TDeviceStatus:Values3=64=:"Device Mirrored",128=:"Reads Mirrored"
  995. TDeviceStatus:Values4=256=:"Half-Mirrored",512=:"Mirror Enabled"
  996. TSegmentStatus:Values=Closed,1=:"Default"
  997.  
  998. MSSQL:UserName=select user_name()
  999. MSSQL:Comments=--;/*,*/
  1000.  
  1001. MSSQL:Objects1=O:C:0M::"Data Types":Type
  1002. MSSQL:Objects2=O:C:0M::"Tables":Table
  1003. MSSQL:Objects3=O:C:0M::"Views":View
  1004. MSSQL:Objects4=O:C:0M::"Procedures":Procedure
  1005. MSSQL:Objects5=O:C:0M::"Defaults":Default
  1006. MSSQL:Objects6=O:C:0M::"Rules":CheckConstraint
  1007. MSSQL:Objects7=O:C:0M::"Logins":Login
  1008. MSSQL:Objects8=O:C:0M::"Groups":Group
  1009. MSSQL:Objects9=O:C:0M::"Users":User
  1010. MSSQL:Objects10=O:C:0M::"Segments":Segment
  1011. MSSQL:Objects11=O:C:0M::"Devices":Device
  1012.  
  1013. dbo.sysobjects:Key=id
  1014. dbo.sysobjects:Name=Owner,name
  1015. dbo.sysobjects:Attrs1=crdate="Creation Date"
  1016. dbo.sysobjects:Attrs2=sysstat="Status":::::VS=TObjectStatus:$1100
  1017. dbo.sysobjects:FilterSystemObjects=user_name(A.uid) <> 'dbo'
  1018.  
  1019. dbo.syscolumns:Key=id,colid
  1020. dbo.syscolumns:Name=name
  1021. dbo.syscolumns:Order=colid
  1022. dbo.syscolumns:Objects1=P:R:M1::"Type":Type
  1023. dbo.syscolumns:Objects2=P:R:M1::"Default Value":Default
  1024. dbo.syscolumns:Objects3=P:R:M1::"Domain Rule":CheckConstraint
  1025. dbo.syscolumns:Reference:"Type"=usertype
  1026. dbo.syscolumns:Reference:"Default Value"=cdefault
  1027. dbo.syscolumns:Reference:"Domain Rule"=domain
  1028. dbo.syscolumns:Attrs1=colid="Order":2:ER
  1029. dbo.syscolumns:Attrs2=length=Length="Length"::E
  1030. dbo.syscolumns:Attrs3=status="Status"::E:::VS=TColumnStatus:$8
  1031.  
  1032. dbo.sysindexes:Key=id,indid
  1033. dbo.sysindexes:Name=name
  1034. dbo.sysindexes:Objects=Q:P:1M::"Columns":IndexColumn
  1035. dbo.sysindexes:Attrs1=status="Status"::E:::VS=TIndexStatus:$FF7F
  1036. dbo.sysindexes:Attrs2=indid="Index Id":2
  1037. dbo.sysindexes:Attrs3=rowpage="Rows per page":2
  1038. dbo.sysindexes:Attrs4=minlen="Minimum row size":2
  1039. dbo.sysindexes:Attrs5=maxlen="Maximum row size":2
  1040.  
  1041. dbo.systypes:Key=usertype
  1042. dbo.systypes:Name=name
  1043. dbo.systypes:Objects1=P:R:M1::"Default Value":Default
  1044. dbo.systypes:Objects2=P:R:M1::"Domain Rule":CheckConstraint
  1045. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  1046. dbo.systypes:Attrs2=length=Length="Length"::E
  1047. dbo.systypes:Attrs3=allownulls=Null="Nulls"::E:::VM=TNull01
  1048. dbo.systypes:Attrs4=variable="Variable Length":::::VM=TBooleanYN
  1049. dbo.systypes:Reference:"Default Value"=tdefault
  1050. dbo.systypes:Reference:"Domain Rule"=domain
  1051.  
  1052. dbo.syssegments:Key=segment
  1053. dbo.syssegments:Name=name
  1054. dbo.syssegments:Attrs1=status="Status":::::VS=TSegmentStatus:$FFFF
  1055.  
  1056. dbo.sysusers:Key=uid
  1057. dbo.sysusers:Name=name
  1058.  
  1059. master.dbo.syslogins:Dataset1=suid,status,accdate,totcpu,totio,spacelimit
  1060. master.dbo.syslogins:Dataset2=timelimit,resultlimit,dbname,name,language
  1061. master.dbo.syslogins:Key=suid
  1062. master.dbo.syslogins:Name=name
  1063. master.dbo.syslogins:Attrs1=dbname="Default Database"
  1064. master.dbo.syslogins:Attrs2=accdate="Last Access"
  1065. master.dbo.syslogins:Attrs3=status="Status":::::VS=TLoginStatus:$FFF7
  1066. master.dbo.syslogins:Attrs4=language="Default Language"
  1067. master.dbo.syslogins:Attrs5=totcpu="Total CPU":2
  1068. master.dbo.syslogins:Attrs6=totio="Total IO":2
  1069.  
  1070. master.dbo.sysdevices:Name=name
  1071. master.dbo.sysdevices:Attrs1=cntrltype="Type":::::VM=TDeviceType
  1072. master.dbo.sysdevices:Attrs2=status="Status":::::VS=TDeviceStatus:$FFFF
  1073. master.dbo.sysdevices:Attrs3=phyname="Physical Name"
  1074. master.dbo.sysdevices:Attrs4=mirrorname="Mirror Name"
  1075. master.dbo.sysdevices:Attrs5=low="First Page"
  1076. master.dbo.sysdevices:Attrs6=high="Last Page"
  1077.  
  1078. Table:Definition=Root=dbo.sysobjects
  1079. View:Definition=Root=dbo.sysobjects
  1080. Procedure:Definition=Root=dbo.sysobjects
  1081. Default:Definition=Root=dbo.sysobjects
  1082. CheckConstraint:Definition=Root=dbo.sysobjects
  1083. Trigger:Definition=Root=dbo.sysobjects
  1084. Type:Definition=Root=dbo.systypes
  1085. Index:Definition=Root=dbo.sysindexes
  1086. Column:Definition=Root=dbo.syscolumns
  1087. Parameter:Definition=Root=dbo.syscolumns
  1088. Segment:Definition=Root=dbo.syssegments
  1089. User:Definition=Root=dbo.sysusers
  1090. Group:Definition=Root=dbo.sysusers
  1091. Database:Definition=Root=master.dbo.sysdatabases
  1092. Login:Definition=Root=master.dbo.syslogins
  1093. Device:Definition=Root=master.dbo.sysdevices
  1094.  
  1095. Table:Category=Dataset
  1096. Table:Values=A.type IN ('U', 'S')
  1097. Table:Objects1=T:P:1M::"Columns":Column
  1098. Table:Objects2=T:O:0M::"Indices":Index
  1099. Table:Objects3=T:O:0M::"Triggers":Trigger
  1100. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *] \N`
  1101. Table:Reference:"Triggers"=id=deltrig
  1102. Table:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1103. Table:AttrReference:Owner=uid=uid
  1104. Table:FilterSystemObjects=A.type <> 'S'
  1105. Table:Warning=DataLoss
  1106. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1107. Table:Text:Get=CREATE TABLE `N` (`{>Column}*`)
  1108. Table:Delete:Text=DROP TABLE `O`
  1109. Table:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1110.  
  1111. View:Category=Dataset
  1112. View:Values=A.type = 'V'
  1113. View:Objects1=T:P:0M:NMDR:"Columns":Column
  1114. View:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1115. View:Attrs:Q=Text=String:255:"Text"::ER
  1116. View:AttrReference:Owner=uid=uid
  1117. View:AttrReference:Text1=select text from dbo.syscomments
  1118. View:AttrReference:Text2=where id=`:id` order by colid
  1119. View:Warning=Loss
  1120. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1121. View:Text:Init=CREATE VIEW View1 AS `\N`  SELECT * FROM owner.object
  1122. View:Text:Get=`=Text`
  1123. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  1124. View:Text:NameSet=1=`N`
  1125. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  1126. View:Text:Set=Text=0,*N=2
  1127. View:Delete:Text=DROP VIEW `O`
  1128.  
  1129. Procedure:Category=Executable
  1130. Procedure:Values=A.type = 'P'
  1131. Procedure:Objects=T:P:0M::"Parameters":Parameter
  1132. Procedure:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1133. Procedure:Attrs:Q=Text=String:255:"Text"::ER
  1134. Procedure:AttrReference:Owner=uid=uid
  1135. Procedure:AttrReference:Text1=select text from dbo.syscomments
  1136. Procedure:AttrReference:Text2=where id=`:id` order by colid
  1137. Procedure:Warning=Loss
  1138. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1139. Procedure:Text:Init=CREATE PROCEDURE Procedure1 AS
  1140. Procedure:Text:Get=`=Text`
  1141. Procedure:Text:NameRE=Text:PROC(EDURE)?\_(\_*\w+)
  1142. Procedure:Text:NameSet=2=`N`
  1143. Procedure:Text:RE=^(.*\_)?CREATE\_+(PROC(EDURE)?)\_+(\w+)\_.*$
  1144. Procedure:Text:Set=2=`'PROCEDURE'`,Text=0,*N=4
  1145. Procedure:Delete:Text=DROP PROCEDURE `O`
  1146. Procedure:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1147.  
  1148. Default:Category=Expression
  1149. Default:Values=A.type = 'D'
  1150. Default:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1151. Default:Attrs:Q=Text=String:255:"Text"::ER
  1152. Default:AttrReference:Owner=uid=uid
  1153. Default:AttrReference:Text1=select text from dbo.syscomments
  1154. Default:AttrReference:Text2=where id=`:id` order by colid
  1155. Default:Warning=Loss
  1156. Default:EAttrs=Text,New,Delete,Modify,Rename,Save
  1157. Default:Text:Init=CREATE DEFAULT Default1 AS default_expression
  1158. Default:Text:Get=`=Text`
  1159. Default:Text:NameRE=Text:DEFAULT\_(\_*\w+)
  1160. Default:Text:NameSet=1=`N`
  1161. Default:Text:RE=^(.*\_)?CREATE\_+DEFAULT\_+(\w+)\_+AS\_+.*$
  1162. Default:Text:Set=Text=0,*N=2
  1163. Default:Delete:Text=DROP DEFAULT `O`
  1164.  
  1165. CheckConstraint:Category=Expression
  1166. CheckConstraint:Values=A.type = 'R'
  1167. CheckConstraint:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1168. CheckConstraint:Attrs:Q=Text=String:255:"Text"::ER
  1169. CheckConstraint:AttrReference:Owner=uid=uid
  1170. CheckConstraint:AttrReference:Text1=select text from dbo.syscomments
  1171. CheckConstraint:AttrReference:Text2=where id=`:id` order by colid
  1172. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1173. CheckConstraint:Text:Init=CREATE RULE Rule1 AS rule_expression
  1174. CheckConstraint:Text:Get=`=Text`
  1175. CheckConstraint:Text:NameRE=Text:RULE\_+(\w+)
  1176. CheckConstraint:Text:NameSet=1=`N`
  1177. CheckConstraint:Text:RE=^(.*\_)?CREATE\_+RULE\_+(\w+)\_+.*$
  1178. CheckConstraint:Text:Set=*N=2,Text=0
  1179. CheckConstraint:Delete:Text=DROP RULE `O`
  1180.  
  1181. Trigger:Category=Executable
  1182. Trigger:Values=A.type = 'TR'
  1183. Trigger:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1184. Trigger:Attrs:Q=Text=String:255:"Text"::ER
  1185. Trigger:AttrReference:Owner=uid=uid
  1186. Trigger:AttrReference:Text1=select text from dbo.syscomments
  1187. Trigger:AttrReference:Text2=where id=`:id` order by colid
  1188. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  1189. Trigger:Text:Init=CREATE TRIGGER Trigger1 ON `{<}N` AS`\N`
  1190. Trigger:Text:Get=`=Text`
  1191. Trigger:Text:NameRE=Text:TRIGGER\_+(\w+)\_+ON\_+(\w+)
  1192. Trigger:Text:NameSet=1=`N`,2=`{<}N`
  1193. Trigger:Text:RE=^(.*\_)?CREATE\_+TRIGGER\_+(\w+)\_+ON\_+(\w+).*$
  1194. Trigger:Text:Set=*N=2,3=`{<}N`,Text=0
  1195. Trigger:Delete:Text=DROP TRIGGER `O`
  1196.  
  1197. RIConstraint:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1198. RIConstraint:AttrReference:Owner=uid=uid
  1199.  
  1200. Column:Category=Column
  1201. Column:Attrs:R=Type:"Type":"Length":1:ER
  1202. Column:EAttrs=Text,New,Delete,Modify,Rename
  1203. Column:Text:Get=`N ' ' EType``! ' ' =status`
  1204.  
  1205. Index:Category=Index
  1206. Index:Values=A.keycnt > 0
  1207. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  1208. Index:Text:Get1=CREATE `=status` INDEX `N`
  1209. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:N]`)
  1210. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  1211. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  1212. Index:Delete:Text=DROP INDEX `{<}O`.`O`
  1213.  
  1214. IndexColumn:Category=ColumnReference
  1215. IndexColumn:Name=Column
  1216. IndexColumn:Order=Id
  1217. IndexColumn:Definition1=Dataset=
  1218. IndexColumn:Definition2=select Id=c.colid, TabId=c.id, ColId=i.colid
  1219. IndexColumn:Definition3=from sysindexes x, syscolumns c, syscolumns i
  1220. IndexColumn:Definition4=where (x.id = `:id`) and (x.id = c.id) and (x.id = i.id) and
  1221. IndexColumn:Definition5=(x.name = '`O`') and (c.colid <= keycnt) and
  1222. IndexColumn:Definition6=(i.name = INDEX_COL('`{<}O`', x.indid, c.colid))
  1223. IndexColumn:Dataset=Id=Word,TabId=Word,ColId=Word
  1224. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  1225. IndexColumn:Attrs1=Id="Order":2:ER
  1226. IndexColumn:Attrs:R=Column:::2:ER
  1227. IndexColumn:Reference:"Column"=TabId,ColId
  1228. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  1229. IndexColumn:Text:Get=`N`
  1230.  
  1231. Parameter:Category=Column
  1232. Parameter:Attrs:R=Type:"Type":"Length":1
  1233. Parameter:EAttrs=
  1234.  
  1235. Type:Category=Type
  1236. Type:Attrs:T=dbo.sysusers.name=Owner:"Owner":Type:1
  1237. Type:AttrReference:Owner=uid=uid
  1238. Type:Warning=Loss
  1239. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  1240. Type:Text:Init=sp_addtype "Type1", "varchar(255)", "null"
  1241. Type:Text:Get=sp_addtype "`N`", "`=Type`"`! ', "' =Null '"'`
  1242. Type:Delete:Text=sp_droptype "`O`"
  1243.  
  1244. Login:Attrs:P=Password=String
  1245. Login:Attrs:R=Password:"Password":"Default Language":2
  1246. Login:EAttrs=Text
  1247. Login:Text:Get=sp_addlogin "`N`", "`=Password`", "`=dbname`", "`=language`"
  1248. Login:Delete:Text=sp_droplogin "`O`"
  1249.  
  1250. Group:Values=A.uid = A.gid
  1251. Group:Objects=P:R:0M::"Users":User
  1252. Group:Reference:"Users"=uid=gid
  1253. Group:EAttrs=Text
  1254. Group:Text:Get=sp_addgroup "`N`"
  1255. Group:Delete:Text=sp_dropgroup "`O`"
  1256.  
  1257. User:Values=A.uid <> A.gid
  1258. User:Objects1=P:R:M1::"Login":Login
  1259. User:Objects2=P:R:M1::"Group":Group
  1260. User:Reference:"Login"=suid
  1261. User:Reference:"Group"=gid
  1262. User:EAttrs=Text
  1263. User:Text:Get=sp_adduser "`=Login`", "`N`", "`=Group`"
  1264. User:Delete:Text=sp_dropuser "`O`"
  1265.  
  1266. Segment:Objects=P:R:M0::"Device":Device
  1267. Segment:Attrs:P=DeviceName=String:::0
  1268. Segment:Reference:"Device"=DeviceName
  1269. Segment:EAttrs=Text
  1270. Segment:Text:Get=sp_addsegment "`N`","`=Device`"
  1271. Segment:Delete:Text=sp_dropsegment "`O`"
  1272.  
  1273. Device:EAttrs=Text
  1274. Device:Text:Get1=DISK INIT NAME="`N`",`\N'  '`PHYSNAME="`=phyname`",
  1275. Device:Text:Get2=`\N'  '`VDEVNO=?,`\N'  '`SIZE=?,
  1276. Device:Text:Get3=`\N'  '`CNTRLTYPE=`=cntrltype`
  1277. Device:Delete:Text=sp_dropdevice "`O`"
  1278.  
  1279. [Sybase Properties]
  1280. TBooleanYN:Values=Closed,0="No",-1="Yes"
  1281. TPhysicalType:Values1=Closed,34=image:"Image",35=text:"Text"
  1282. TPhysicalType:Values2=37=`'varbinary'``!'('=Length')'`:"VarBinary"
  1283. TPhysicalType:Values3=38=int:"Int"
  1284. TPhysicalType:Values4=39=`'varchar'``!'('=Length')'`:"VarChar"
  1285. TPhysicalType:Values5=45=`'binary'``!'('=Length')'`:"Binary"
  1286. TPhysicalType:Values6=47=`'char'``!'('=Length')'`:"Char"
  1287. TPhysicalType:Values7=48=tinyint:"TinyInt",50=bit:"Bit"
  1288. TPhysicalType:Values8=52=smallint:"SmallInt",55=decimal:"Decimal",56=int:"Int"
  1289. TPhysicalType:Values9=58=smalldatetime:"SmallDateTime",59=real:"Real"
  1290. TPhysicalType:Values10=60=money:"Money",61=datetime:"DateTime",62=float:"Float"
  1291. TPhysicalType:Values11=63=numeric:"Numeric",106=decimal:"Decimal"
  1292. TPhysicalType:Values12=108=numeric:"Numeric",109=float:"Float",110=money:"Money"
  1293. TPhysicalType:Values13=111=datetime:"DateTime",122=smallmoney:"SmallMoney"
  1294. TNull01:Values=Closed,0=not null:"No",-1=null:"Yes"
  1295. TObjectType:Values1=Closed,S="System Table",U="Table",V="View",L="Log",P="Procedure",
  1296. TObjectType:Values2=R="Rule",D="Default",TR="Trigger",RI="Referential Constraint"
  1297. TObjectStatus:Values=Closed,256="Read Only",4096="RamboIX"
  1298. TColumnStatus:Values=Closed,8=NULL:"Null"
  1299. TIndexStatus:Values1=Closed,2=UNIQUE:"Unique",16=CLUSTERED:"Clustered"
  1300. TIndexStatus:Values2=1=:"Dup Key Abort",4=:"Dup Row Abort"
  1301. TIndexStatus:Values3=64=:"Allow Dup Rows",32768=:"Suspect"
  1302. TLoginStatus:Values=Closed,1=:"Small Password",2=:"Locked account",4=:"Password Expired"
  1303. TDeviceType:Values1=Closed,0=0:"Database",2=2:"Disk Dump",3=3:"Tape Dump",4=4:"Tape Dump"
  1304. TDeviceType:Values2=5=5:"Tape Dump",6=6:"Tape Dump",7=7:"Tape Dump",8=8:"Tape Dump"
  1305. TDeviceStatus:Values1=Closed,1=:"Default",2=:"Physical Disk",4=:"Logical Disk"
  1306. TDeviceStatus:Values2=8=:"Skip Header",16=:"Dump Device",32=:"Serial Writes"
  1307. TDeviceStatus:Values3=64=:"Device Mirrored",128=:"Reads Mirrored"
  1308. TDeviceStatus:Values4=256=:"Half-Mirrored",512=:"Mirror Enabled"
  1309. TSegmentStatus:Values=Closed,1=:"Default"
  1310.  
  1311. Sybase:UserName=select user_name()
  1312. Sybase:Comments=--;/*,*/
  1313.  
  1314. Sybase:Objects1=O:C:0M::"Data Types":Type
  1315. Sybase:Objects2=O:C:0M::"Tables":Table
  1316. Sybase:Objects3=O:C:0M::"Views":View
  1317. Sybase:Objects4=O:C:0M::"Procedures":Procedure
  1318. Sybase:Objects5=O:C:0M::"Defaults":Default
  1319. Sybase:Objects6=O:C:0M::"Rules":CheckConstraint
  1320. Sybase:Objects7=O:C:0M::"Logins":Login
  1321. Sybase:Objects8=O:C:0M::"Groups":Group
  1322. Sybase:Objects9=O:C:0M::"Users":User
  1323. Sybase:Objects10=O:C:0M::"Segments":Segment
  1324. Sybase:Objects11=O:C:0M::"Devices":Device
  1325.  
  1326. dbo.sysobjects:Key=id
  1327. dbo.sysobjects:Name=Owner,name
  1328. dbo.sysobjects:Attrs1=crdate="Creation Date"
  1329. dbo.sysobjects:Attrs2=sysstat="Status":::::VS=TObjectStatus:$1100
  1330. dbo.sysobjects:FilterSystemObjects=user_name(A.uid) <> 'dbo'
  1331. dbo.sysobjects:Dataset1=name,id,uid,type,userstat,sysstat,indexdel,
  1332. dbo.sysobjects:Dataset2=crdate,expdate,deltrig,instrig,updtrig,seltrig
  1333.  
  1334. dbo.syscolumns:Key=id,colid
  1335. dbo.syscolumns:Name=name
  1336. dbo.syscolumns:Order=colid
  1337. dbo.syscolumns:Objects1=P:R:M1::"Type":Type
  1338. dbo.syscolumns:Objects2=P:R:M1::"Default Value":Default
  1339. dbo.syscolumns:Objects3=P:R:M1::"Domain Rule":CheckConstraint
  1340. dbo.syscolumns:Reference:"Type"=usertype
  1341. dbo.syscolumns:Reference:"Default Value"=cdefault
  1342. dbo.syscolumns:Reference:"Domain Rule"=domain
  1343. dbo.syscolumns:Attrs1=colid="Order":2:ER
  1344. dbo.syscolumns:Attrs2=length=Length="Length"::E
  1345. dbo.syscolumns:Attrs3=status="Status"::E:::VS=TColumnStatus:$8
  1346.  
  1347. dbo.sysindexes:Key=id,indid
  1348. dbo.sysindexes:Name=name
  1349. dbo.sysindexes:Objects=Q:P:1M::"Columns":IndexColumn
  1350. dbo.sysindexes:Attrs1=status="Status"::E:::VS=TIndexStatus:$8077
  1351. dbo.sysindexes:Attrs2=indid="Index Id":2
  1352. dbo.sysindexes:Attrs3=minlen="Minimum row size":2
  1353. dbo.sysindexes:Attrs4=maxlen="Maximum row size":2
  1354.  
  1355. dbo.systypes:Key=usertype
  1356. dbo.systypes:Name=name
  1357. dbo.systypes:Objects1=P:R:M1::"Default Value":Default
  1358. dbo.systypes:Objects2=P:R:M1::"Domain Rule":CheckConstraint
  1359. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  1360. dbo.systypes:Attrs2=length=Length="Length"::E
  1361. dbo.systypes:Attrs3=allownulls=Null="Nulls"::E:::VM=TNull01
  1362. dbo.systypes:Attrs4=variable="Variable Length":::::VM=TBooleanYN
  1363. dbo.systypes:Reference:"Default Value"=tdefault
  1364. dbo.systypes:Reference:"Domain Rule"=domain
  1365.  
  1366. dbo.syssegments:Key=segment
  1367. dbo.syssegments:Name=name
  1368. dbo.syssegments:Attrs1=status="Status":::::VS=TSegmentStatus:$FFFF
  1369.  
  1370. dbo.sysusers:Key=uid
  1371. dbo.sysusers:Name=name
  1372.  
  1373. master.dbo.syslogins:Dataset1=suid,status,accdate,totcpu,totio,spacelimit
  1374. master.dbo.syslogins:Dataset2=timelimit,resultlimit,dbname,name,language
  1375. master.dbo.syslogins:Key=suid
  1376. master.dbo.syslogins:Name=name
  1377. master.dbo.syslogins:Attrs1=dbname="Default Database"
  1378. master.dbo.syslogins:Attrs2=accdate="Last Access"
  1379. master.dbo.syslogins:Attrs3=status="Status":::::VS=TLoginStatus:$FFF7
  1380. master.dbo.syslogins:Attrs4=language="Default Language"
  1381. master.dbo.syslogins:Attrs5=totcpu="Total CPU":2
  1382. master.dbo.syslogins:Attrs6=totio="Total IO":2
  1383.  
  1384. master.dbo.sysdevices:Name=name
  1385. master.dbo.sysdevices:Attrs1=cntrltype="Type":::::VM=TDeviceType
  1386. master.dbo.sysdevices:Attrs2=status="Status":::::VS=TDeviceStatus:$FFFF
  1387. master.dbo.sysdevices:Attrs3=phyname="Physical Name"
  1388. master.dbo.sysdevices:Attrs4=mirrorname="Mirror Name"
  1389. master.dbo.sysdevices:Attrs5=low="First Page"
  1390. master.dbo.sysdevices:Attrs6=high="Last Page"
  1391.  
  1392. Table:Definition=Root=dbo.sysobjects
  1393. View:Definition=Root=dbo.sysobjects
  1394. Procedure:Definition=Root=dbo.sysobjects
  1395. Default:Definition=Root=dbo.sysobjects
  1396. CheckConstraint:Definition=Root=dbo.sysobjects
  1397. Trigger:Definition=Root=dbo.sysobjects
  1398. Type:Definition=Root=dbo.systypes
  1399. Index:Definition=Root=dbo.sysindexes
  1400. Column:Definition=Root=dbo.syscolumns
  1401. Parameter:Definition=Root=dbo.syscolumns
  1402. Segment:Definition=Root=dbo.syssegments
  1403. User:Definition=Root=dbo.sysusers
  1404. Group:Definition=Root=dbo.sysusers
  1405. Database:Definition=Root=master.dbo.sysdatabases
  1406. Login:Definition=Root=master.dbo.syslogins
  1407. Device:Definition=Root=master.dbo.sysdevices
  1408.  
  1409. Table:Category=Dataset
  1410. Table:Values=A.type IN ('U', 'S')
  1411. Table:Objects1=T:P:1M::"Columns":Column
  1412. Table:Objects2=T:O:0M::"Indices":Index
  1413. Table:Objects3=T:O:0M::"Triggers":Trigger
  1414. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *] \N`
  1415. Table:Reference:"Triggers"=id=deltrig
  1416. Table:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1417. Table:AttrReference:Owner=uid=uid
  1418. Table:FilterSystemObjects=A.type <> 'S'
  1419. Table:Warning=DataLoss
  1420. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1421. Table:Text:Get=CREATE TABLE `N` (`{>Column}*`)
  1422. Table:Delete:Text=DROP TABLE `O`
  1423. Table:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1424.  
  1425. View:Category=Dataset
  1426. View:Values=A.type = 'V'
  1427. View:Objects1=T:P:0M:NMDR:"Columns":Column
  1428. View:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1429. View:Attrs:Q=Text=String:255:"Text"::ER
  1430. View:AttrReference:Owner=uid=uid
  1431. View:AttrReference:Text1=select text from dbo.syscomments
  1432. View:AttrReference:Text2=where id=`:id` order by colid
  1433. View:Warning=Loss
  1434. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1435. View:Text:Init=CREATE VIEW View1 AS `\N`  SELECT * FROM owner.table
  1436. View:Text:Get=`=Text`
  1437. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  1438. View:Text:NameSet=1=`N`
  1439. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  1440. View:Text:Set=Text=0,*N=2
  1441. View:Delete:Text=DROP VIEW `O`
  1442.  
  1443. Procedure:Category=Executable
  1444. Procedure:Values=A.type = 'P'
  1445. Procedure:Objects=T:P:0M::"Parameters":Parameter
  1446. Procedure:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1447. Procedure:Attrs:Q=Text=String:255:"Text"::ER
  1448. Procedure:AttrReference:Owner=uid=uid
  1449. Procedure:AttrReference:Text1=select text from dbo.syscomments
  1450. Procedure:AttrReference:Text2=where id=`:id` order by colid
  1451. Procedure:Warning=Loss
  1452. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1453. Procedure:Text:Init=CREATE PROCEDURE Procedure1 AS
  1454. Procedure:Text:Get=`=Text`
  1455. Procedure:Text:NameRE=Text:PROC(EDURE)?\_(\_*\w+)
  1456. Procedure:Text:NameSet=2=`N`
  1457. Procedure:Text:RE=^(.*\_)?CREATE\_+(PROC(EDURE)?)\_+(\w+)\_.*$
  1458. Procedure:Text:Set=2=`'PROCEDURE'`,Text=0,*N=4
  1459. Procedure:Delete:Text=DROP PROCEDURE `O`
  1460. Procedure:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1461.  
  1462. Default:Category=Expression
  1463. Default:Values=A.type = 'D'
  1464. Default:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1465. Default:Attrs:Q=Text=String:255:"Text"::ER
  1466. Default:AttrReference:Owner=uid=uid
  1467. Default:AttrReference:Text1=select text from dbo.syscomments
  1468. Default:AttrReference:Text2=where id=`:id` order by colid
  1469. Default:Warning=Loss
  1470. Default:EAttrs=Text,New,Delete,Modify,Rename,Save
  1471. Default:Text:Init=CREATE DEFAULT Default1 AS default_expression
  1472. Default:Text:Get=`=Text`
  1473. Default:Text:NameRE=Text:DEFAULT\_(\_*\w+)
  1474. Default:Text:NameSet=1=`N`
  1475. Default:Text:RE=^(.*\_)?CREATE\_+DEFAULT\_+(\w+)\_+AS\_+.*$
  1476. Default:Text:Set=Text=0,*N=2
  1477. Default:Delete:Text=DROP DEFAULT `O`
  1478.  
  1479. CheckConstraint:Category=Expression
  1480. CheckConstraint:Values=A.type = 'R'
  1481. CheckConstraint:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1482. CheckConstraint:Attrs:Q=Text=String:255:"Text"::ER
  1483. CheckConstraint:AttrReference:Owner=uid=uid
  1484. CheckConstraint:AttrReference:Text1=select text from dbo.syscomments
  1485. CheckConstraint:AttrReference:Text2=where id=`:id` order by colid
  1486. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1487. CheckConstraint:Text:Init=CREATE RULE Rule1 AS rule_expression
  1488. CheckConstraint:Text:Get=`=Text`
  1489. CheckConstraint:Text:NameRE=Text:RULE\_+(\w+)
  1490. CheckConstraint:Text:NameSet=1=`N`
  1491. CheckConstraint:Text:RE=^(.*\_)?CREATE\_+RULE\_+(\w+)\_+.*$
  1492. CheckConstraint:Text:Set=*N=2,Text=0
  1493. CheckConstraint:Delete:Text=DROP RULE `O`
  1494.  
  1495. Trigger:Category=Executable
  1496. Trigger:Values=A.type = 'TR'
  1497. Trigger:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1498. Trigger:Attrs:Q=Text=String:255:"Text"::ER
  1499. Trigger:AttrReference:Owner=uid=uid
  1500. Trigger:AttrReference:Text1=select text from dbo.syscomments
  1501. Trigger:AttrReference:Text2=where id=`:id` order by colid
  1502. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  1503. Trigger:Text:Init=CREATE TRIGGER Trigger1 ON `{<}N` AS`\N`
  1504. Trigger:Text:Get=`=Text`
  1505. Trigger:Text:NameRE=Text:TRIGGER\_+(\w+)\_+ON\_+(\w+)
  1506. Trigger:Text:NameSet=1=`N`,2=`{<}N`
  1507. Trigger:Text:RE=^(.*\_)?CREATE\_+TRIGGER\_+(\w+)\_+ON\_+(\w+).*$
  1508. Trigger:Text:Set=*N=2,3=`{<}N`,Text=0
  1509. Trigger:Delete:Text=DROP TRIGGER `O`
  1510.  
  1511. RIConstraint:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1512. RIConstraint:AttrReference:Owner=uid=uid
  1513.  
  1514. Column:Category=Column
  1515. Column:Attrs:R=Type:"Type":"Length":1:ER
  1516. Column:EAttrs=Text,New,Delete,Modify,Rename
  1517. Column:Text:Get=`N ' ' EType``! ' ' =status`
  1518.  
  1519. Index:Category=Index
  1520. Index:Values=A.keycnt > 0
  1521. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  1522. Index:Text:Get1=CREATE `=status` INDEX `N`
  1523. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:N]`)
  1524. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  1525. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  1526. Index:Delete:Text=DROP INDEX `{<}O`.`O`
  1527.  
  1528. IndexColumn:Category=ColumnReference
  1529. IndexColumn:Name=Column
  1530. IndexColumn:Order=Id
  1531. IndexColumn:Definition1=Dataset=
  1532. IndexColumn:Definition2=select Id=c.colid, TabId=c.id, ColId=i.colid
  1533. IndexColumn:Definition3=from sysindexes x, syscolumns c, syscolumns i
  1534. IndexColumn:Definition4=where (x.id = `:id`) and (x.id = c.id) and (x.id = i.id) and
  1535. IndexColumn:Definition5=(x.name = '`O`') and (c.colid <= keycnt) and
  1536. IndexColumn:Definition6=(i.name = INDEX_COL('`{<}O`', x.indid, c.colid))
  1537. IndexColumn:Dataset=Id=Word,TabId=Word,ColId=Word
  1538. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  1539. IndexColumn:Attrs1=Id="Order":2:ER
  1540. IndexColumn:Attrs:R=Column:::2:ER
  1541. IndexColumn:Reference:"Column"=TabId,ColId
  1542. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  1543. IndexColumn:Text:Get=`N`
  1544.  
  1545. Parameter:Category=Column
  1546. Parameter:Attrs:R=Type:"Type":"Length":1
  1547. Parameter:EAttrs=
  1548.  
  1549. Type:Category=Type
  1550. Type:Attrs:T=dbo.sysusers.name=Owner:"Owner":Type:1
  1551. Type:AttrReference:Owner=uid=uid
  1552. Type:Warning=Loss
  1553. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  1554. Type:Text:Init=sp_addtype "Type1", "varchar(255)", "null"
  1555. Type:Text:Get=sp_addtype "`N`", "`=Type`"`! ', "' =Null '"'`
  1556. Type:Delete:Text=sp_droptype "`O`"
  1557.  
  1558. Login:Attrs:P=Password=String
  1559. Login:Attrs:R=Password:"Password":"Default Language":2
  1560. Login:EAttrs=Text
  1561. Login:Text:Get=sp_addlogin "`N`", "`=Password`", "`=dbname`", "`=language`"
  1562. Login:Delete:Text=sp_droplogin "`O`"
  1563.  
  1564. Group:Values=A.uid = A.gid
  1565. Group:Objects=P:R:0M::"Users":User
  1566. Group:Reference:"Users"=uid=gid
  1567. Group:EAttrs=Text
  1568. Group:Text:Get=sp_addgroup "`N`"
  1569. Group:Delete:Text=sp_dropgroup "`O`"
  1570.  
  1571. User:Values=A.uid <> A.gid
  1572. User:Objects1=P:R:M1::"Login":Login
  1573. User:Objects2=P:R:M1::"Group":Group
  1574. User:Reference:"Login"=suid
  1575. User:Reference:"Group"=gid
  1576. User:EAttrs=Text
  1577. User:Text:Get=sp_adduser "`=Login`", "`N`", "`=Group`"
  1578. User:Delete:Text=sp_dropuser "`O`"
  1579.  
  1580. Segment:Objects=P:R:M0::"Device":Device
  1581. Segment:Attrs:P=DeviceName=String:::0
  1582. Segment:Reference:"Device"=DeviceName
  1583. Segment:EAttrs=Text
  1584. Segment:Text:Get=sp_addsegment "`N`","`=Device`"
  1585. Segment:Delete:Text=sp_dropsegment "`O`"
  1586.  
  1587. Device:EAttrs=Text
  1588. Device:Text:Get1=DISK INIT NAME="`N`",`\N'  '`PHYSNAME="`=phyname`",
  1589. Device:Text:Get2=`\N'  '`VDEVNO=?,`\N'  '`SIZE=?,
  1590. Device:Text:Get3=`\N'  '`CNTRLTYPE=`=cntrltype`
  1591. Device:Delete:Text=sp_dropdevice "`O`"
  1592.  
  1593. [InterBase Properties]
  1594. TFieldType:Values1=Closed,7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  1595. TFieldType:Values2=11=DOUBLE PRECISION,14=`'CHAR('=Length')'`:CHAR,27=NUMERIC
  1596. TFieldType:Values3=35=DATE,37=`'VARCHAR('=Length')'`:VARCHAR
  1597. TFieldType:Values4=40=`'CSTRING('=Length')'`:CSTRING
  1598. TFieldType:Values5=261=`'BLOB'``!' SUB_TYPE ' =SubType`:BLOB
  1599. TFieldSubType:Values1=Closed,0=0:,1=1:"Text",2=2:"BLR",3=3:"ACL",4=4:"Ranges",5=5:"Summary"
  1600. TFieldSubType:Values2=6=6:"Format",7=7:"Transaction Desc",8=8:"Ext File Desc"
  1601. TNulls:Values=Closed,=:"Yes",1=NOT NULL:"No"
  1602. TUniqueIndex:Values=Closed,=:"No",0=:"No",1=UNIQUE:"Yes"
  1603. TDescendingIndex:Values=Closed,=ASCENDING:"No",1=DESCENDING:"Yes"
  1604. TTriggerType:Values1=Closed,1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  1605. TTriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  1606. TParamKind:Values=Closed,0=:"Input",1=:"Output"
  1607. TFnParamKind:Values=Closed,0=BY VALUE:"Value",1=:"Reference",3=:"Handle"
  1608.  
  1609. InterBase:Comments=/*,*/
  1610.  
  1611. InterBase:Objects1=O:C:0M::"Domains":Type
  1612. InterBase:Objects2=O:C:0M::"Tables":Table
  1613. InterBase:Objects3=O:C:0M::"Views":View
  1614. InterBase:Objects4=O:C:0M::"Procedures":Procedure
  1615. InterBase:Objects5=O:C:0M::"Functions":Function
  1616. InterBase:Objects6=O:C:0M::"Generators":Generator
  1617. InterBase:Objects7=O:C:0M::"Exceptions":Exception
  1618. InterBase:Objects8=O:C:0M::"Blob Filters":BlobFilter
  1619.  
  1620. RDB$RELATIONS:Name=RDB$RELATION_NAME
  1621. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Owner"
  1622. RDB$RELATIONS:Attrs2=RDB$DESCRIPTION="Description"
  1623. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  1624.  
  1625. RDB$RELATION_FIELDS:Key=RDB$RELATION_NAME,RDB$FIELD_NAME
  1626. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  1627. RDB$RELATION_FIELDS:Order=RDB$FIELD_POSITION
  1628. RDB$RELATION_FIELDS:Objects=P:R:M1::"Domain":Type
  1629. RDB$RELATION_FIELDS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  1630. RDB$RELATION_FIELDS:Attrs2=RDB$DEFAULT_SOURCE=Default="Default"::E
  1631. RDB$RELATION_FIELDS:Attrs3=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  1632. RDB$RELATION_FIELDS:Reference:"Domain"=RDB$FIELD_SOURCE
  1633.  
  1634. RDB$FIELDS:Name=RDB$FIELD_NAME
  1635. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  1636. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  1637. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH=Length="Length"::E
  1638. RDB$FIELDS:Attrs4=RDB$FIELD_SCALE=Scale="Scale"::E
  1639. RDB$FIELDS:Attrs5=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  1640. RDB$FIELDS:Attrs6=RDB$SEGMENT_LENGTH=SegmentSize="Segment Size":2:E
  1641. RDB$FIELDS:Attrs7=RDB$DEFAULT_SOURCE=Default="Default":2:E
  1642. RDB$FIELDS:Attrs8=RDB$VALIDATION_SOURCE=Constraint="Constraint":2:E
  1643. RDB$FIELDS:Attrs9=RDB$DESCRIPTION=Description="Description"
  1644.  
  1645. RDB$FIELD_DIMENSIONS:Key=RDB$FIELD_NAME,RDB$DIMENSION
  1646. RDB$FIELD_DIMENSIONS:Name=RDB$DIMENSION
  1647. RDB$FIELD_DIMENSIONS:Order=RDB$DIMENSION
  1648. RDB$FIELD_DIMENSIONS:Attrs1=RDB$DIMENSION="Order":2:ER
  1649. RDB$FIELD_DIMENSIONS:Attrs2=RDB$LOWER_BOUND=LowerBound="Lower Bound"::ER
  1650. RDB$FIELD_DIMENSIONS:Attrs3=RDB$UPPER_BOUND=UpperBound="Upper Bound"::ER
  1651.  
  1652. RDB$FUNCTIONS:Name=RDB$FUNCTION_NAME
  1653. RDB$FUNCTIONS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  1654. RDB$FUNCTIONS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  1655. RDB$FUNCTIONS:Attrs3=RDB$QUERY_NAME=AlternateName="Alternate Name"
  1656. RDB$FUNCTIONS:Attrs4=RDB$DESCRIPTION=Description="Description":2
  1657. RDB$FUNCTIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  1658.  
  1659. RDB$FUNCTION_ARGUMENTS:Key=RDB$FUNCTION_NAME,RDB$ARGUMENT_POSITION
  1660. RDB$FUNCTION_ARGUMENTS:Name=RDB$ARGUMENT_POSITION
  1661. RDB$FUNCTION_ARGUMENTS:Order=RDB$ARGUMENT_POSITION
  1662. RDB$FUNCTION_ARGUMENTS:Attrs1=RDB$ARGUMENT_POSITION="Order":2:ER
  1663. RDB$FUNCTION_ARGUMENTS:Attrs2=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  1664. RDB$FUNCTION_ARGUMENTS:Attrs3=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  1665. RDB$FUNCTION_ARGUMENTS:Attrs4=RDB$FIELD_LENGTH=Length="Length"::E
  1666. RDB$FUNCTION_ARGUMENTS:Attrs5=RDB$FIELD_SCALE=Scale="Scale"::E
  1667.  
  1668. RDB$FILTERS:Name=RDB$FUNCTION_NAME
  1669. RDB$FILTERS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  1670. RDB$FILTERS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  1671. RDB$FILTERS:Attrs3=RDB$INPUT_SUB_TYPE=InputType="Input"::ER:::VM=TFieldSubType
  1672. RDB$FILTERS:Attrs4=RDB$OUTPUT_SUB_TYPE=OutputType="Output"::ER:::VM=TFieldSubType
  1673. RDB$FILTERS:Attrs5=RDB$DESCRIPTION=Description="Description":2
  1674. RDB$FILTERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  1675.  
  1676. RDB$INDICES:Name=RDB$INDEX_NAME
  1677. RDB$INDICES:Objects=T:P:1M::"Columns":IndexColumn
  1678. RDB$INDICES:Attrs1=RDB$UNIQUE_FLAG=Unique="Unique"::E:::VM=TUniqueIndex
  1679. RDB$INDICES:Attrs2=RDB$INDEX_TYPE=Descending="Descending"::E:::VM=TDescendingIndex
  1680. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  1681.  
  1682. RDB$INDEX_SEGMENTS:Key=RDB$INDEX_NAME,RDB$FIELD_NAME
  1683. RDB$INDEX_SEGMENTS:Name=Column
  1684. RDB$INDEX_SEGMENTS:Order=RDB$FIELD_POSITION
  1685. RDB$INDEX_SEGMENTS:Objects1=P:R:M1::"Column":Column:<<>Column
  1686. RDB$INDEX_SEGMENTS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  1687. RDB$INDEX_SEGMENTS:Reference:"Column"=,RDB$FIELD_NAME
  1688.  
  1689. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  1690. RDB$PROCEDURES:Attrs1=RDB$OWNER_NAME="Owner"
  1691. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  1692.  
  1693. RDB$PROCEDURE_PARAMETERS:Key=RDB$PROCEDURE_NAME,RDB$PARAMETER_NAME
  1694. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  1695. RDB$PROCEDURE_PARAMETERS:Order=RDB$PARAMETER_NUMBER
  1696. RDB$PROCEDURE_PARAMETERS:Objects=P:R:M1::"Domain":Type
  1697. RDB$PROCEDURE_PARAMETERS:Attrs1=RDB$PARAMETER_NUMBER="Order":2
  1698. RDB$PROCEDURE_PARAMETERS:Attrs2=RDB$PARAMETER_TYPE=Kind="Kind":1:ER:::VM=TParamKind
  1699. RDB$PROCEDURE_PARAMETERS:Reference:"Domain"=RDB$FIELD_SOURCE
  1700.  
  1701. RDB$TYPES:Key=RDB$FIELD_NAME,RDB$TYPE
  1702. RDB$TYPES:Name=RDB$TYPE_NAME
  1703. RDB$TYPES:Order=RDB$TYPE
  1704. RDB$TYPES:Attrs=RDB$TYPE="Value"
  1705.  
  1706. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  1707. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  1708.  
  1709. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  1710. RDB$EXCEPTIONS:Attrs1=RDB$MESSAGE=Message="Message"::E
  1711.  
  1712. RDB$TRIGGERS:Key=RDB$RELATION_NAME,RDB$TRIGGER_NAME
  1713. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  1714. RDB$TRIGGERS:Objects=P:R:M1::"Table":Table
  1715. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE="Type":::::VM=TTriggerType
  1716. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE="Position"
  1717. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  1718.  
  1719. RDB$RELATION_CONSTRAINTS:Key=RDB$RELATION_NAME,RDB$CONSTRAINT_NAME
  1720. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  1721. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Can Defer"
  1722. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="Initially Deferred"
  1723. RDB$RELATION_CONSTRAINTS:Reference:"Columns"=RDB$INDEX_NAME
  1724.  
  1725. RDB$REF_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  1726. RDB$REF_CONSTRAINTS:Objects1=P:R:01::"Primary Key":PrimaryKey
  1727. RDB$REF_CONSTRAINTS:Objects2=P:R:11::"Foreign Key":ForeignKey
  1728. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Foreign Key"
  1729. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="Primary Key"
  1730. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="Match Option"
  1731. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Update Rule"
  1732. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="Delete Rule"
  1733. RDB$REF_CONSTRAINTS:Reference:"PrimaryKey"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  1734. RDB$REF_CONSTRAINTS:Reference:"ForeignKey"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  1735.  
  1736. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  1737. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  1738.  
  1739. Table:Definition=Root=RDB$RELATIONS
  1740. View:Definition=Root=RDB$RELATIONS
  1741. Procedure:Definition=Root=RDB$PROCEDURES
  1742. Function:Definition=Root=RDB$FUNCTIONS
  1743. Trigger:Definition=Root=RDB$TRIGGERS
  1744. PrimaryKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  1745. ForeignKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  1746. UniqueConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  1747. CheckConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  1748. Exception:Definition=Root=RDB$EXCEPTIONS
  1749. Generator:Definition=Root=RDB$GENERATORS
  1750. Index:Definition=Root=RDB$INDICES
  1751. IndexColumn:Definition=Root=RDB$INDEX_SEGMENTS
  1752. Column:Definition=Root=RDB$RELATION_FIELDS
  1753. Type:Definition=Root=RDB$FIELDS
  1754. Enumeration:Definition=Root=RDB$TYPES
  1755. Parameter:Definition=Root=RDB$PROCEDURE_PARAMETERS
  1756. FunctionParameter:Definition=Root=RDB$FUNCTION_ARGUMENTS
  1757. FunctionResult:Definition=Root=RDB$FUNCTION_ARGUMENTS
  1758. BlobFilter:Definition=Root=RDB$FILTERS
  1759. Dimension:Definition=Root=RDB$FIELD_DIMENSIONS
  1760.  
  1761. Exception:Warning=Loss
  1762. Exception:EAttrs=Text,New,Delete,Modify,Rename,Save
  1763. Exception:Text:Get=CREATE EXCEPTION `\N '  ' N \N`  "`=Message`"
  1764. Exception:Text:RE=CREATE EXCEPTION\_+(\w+)\_+"(.*)"
  1765. Exception:Text:Set=*N=1,Message=2
  1766. Exception:Delete:Text=DROP EXCEPTION `O`
  1767.  
  1768. Generator:Attrs:Q=gen_id=Integer::"Current Value":2:ER
  1769. Generator:AttrReference:gen_id=select distinct gen_id(`O`, 0) from RDB$GENERATORS
  1770. Generator:Warning=Loss
  1771. Generator:EAttrs=Text,New:';',Delete,Modify,Rename,Save
  1772. Generator:Text:Init=CREATE GENERATOR Generator1;`\N 'SET GENERATOR Generator1 TO 0'`
  1773. Generator:Text:Get=CREATE GENERATOR `N`;`\N 'SET GENERATOR ' N ' TO ' =gen_id`
  1774. Generator:Text:RE=CREATE GENERATOR\_+(\w+);(\_*SET GENERATOR \w+ TO (\w*))?\_*$
  1775. Generator:Text:Set=*N=1,gen_id=3
  1776. Generator:Delete:Text1=DELETE FROM RDB$GENERATORS
  1777. Generator:Delete:Text2=WHERE RDB$GENERATOR_NAME = '`O`'
  1778.  
  1779. Table:Category=Dataset
  1780. Table:Values=A.RDB$VIEW_SOURCE IS NULL
  1781. Table:Objects1=T:P:1M::"Columns":Column
  1782. Table:Objects2=T:O:0M::"Indices":Index
  1783. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  1784. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  1785. Table:Objects5=T:O:0M::"Check Constraints":CheckConstraint
  1786. Table:Objects6=T:O:0M::"Unique Constraints":UniqueConstraint
  1787. Table:Objects7=T:O:0M::"Triggers":Trigger
  1788. Table:Reference:"Indices"=RDB$RELATION_NAME=RDB$RELATION_NAME
  1789. Table:Warning=DataLoss
  1790. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1791. Table:Text:Get=CREATE TABLE `N` (`[Column:%s,%s:\N '  ' *] \N`)
  1792. Table:Text:RE=CREATE TABLE\_+(\w+)\_*(\(.*\))
  1793. Table:Text:Set=*N=1
  1794. Table:Delete:Text=DROP TABLE `O`
  1795.  
  1796. View:Category=Dataset
  1797. View:Values=A.RDB$VIEW_SOURCE IS NOT NULL
  1798. View:Objects=T:P:0M:NMDR:"Columns":Column
  1799. View:Attrs:Q=Text=Memo::"Text"::ER
  1800. View:AttrReference:Text1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  1801. View:AttrReference:Text2=where RDB$RELATION_ID=`:RDB$RELATION_ID`
  1802. View:Warning=Loss
  1803. View:EAttrs=Data,Text,New,Modify,Rename,Delete,Save
  1804. View:Text:Init=CREATE VIEW View1 AS SELECT
  1805. View:Text:Get=CREATE VIEW `N` `'('[Column:%s,%s:\N '  ' N] \N ') '`AS` =Text`
  1806. View:Text:RE=CREATE VIEW\_+(\w+)\_*(\(.*\))?\_+AS(.*)
  1807. View:Text:Set=Text=3,*N=1
  1808. View:Delete:Text=DROP VIEW `O`
  1809.  
  1810. Index:Category=Index
  1811. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  1812. Index:Text:Get1=CREATE `!=Unique ' ' ``!=Descending ' ' `INDEX `N`
  1813. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:*]`)
  1814. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  1815. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  1816. Index:Delete:Text=DROP INDEX `O`
  1817.  
  1818. Column:Category=Column
  1819. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:E::EResetType
  1820. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:E::EResetType
  1821. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:E::EResetType
  1822. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:E::EResetType
  1823. Column:Attrs:R=Type:"Domain":"Type":1:E::ESetType
  1824. ; Convert DEFAULT (.*) in Default
  1825. Column:OnAfterLoad=ColumnLoaded
  1826. Column:AttrReference:FieldType=RDB$FIELD_SOURCE
  1827. Column:AttrReference:SubType=RDB$FIELD_SOURCE
  1828. Column:AttrReference:Length=RDB$FIELD_SOURCE
  1829. Column:AttrReference:Scale=RDB$FIELD_SOURCE
  1830. Column:EAttrs=Text,New,Delete,Modify,Rename
  1831. Column:Text:Get=`N ' ' EType``! ' DEFAULT ' =Default``! ' ' =Null`
  1832.  
  1833. IndexColumn:Category=ColumnReference
  1834. IndexColumn:Attrs:R=Column:::2:ER
  1835. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  1836. IndexColumn:Text:Get=`N`
  1837.  
  1838. Type:Category=Type
  1839. Type:Objects1=T:P:0M::"Dimensions":Dimension
  1840. Type:Objects2=T:C:0M::"Values":Enumeration
  1841. ; Convert DEFAULT (.*) in Default and CHECK \((.*)\) in Constraint
  1842. Type:OnAfterLoad=TypeLoaded
  1843. Type:Reference:"Dimensions":Text=`' [' [Dimension:%s, %s:*] ']'`
  1844. Type:Warning=Loss
  1845. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  1846. Type:Text:Get1=CREATE DOMAIN `N` AS` \N '  ' EPhysicalType`
  1847. Type:Text:Get2=`!\N '  DEFAULT '=Default`
  1848. Type:Text:Get3=`!\N '  ' =Null`
  1849. Type:Text:Get4=`!\N '  CHECK (' =Constraint ')'`
  1850. Type:Delete:Text=DROP DOMAIN `O`
  1851.  
  1852. Dimension:EAttrs=Text,New,Delete,Modify,Rename
  1853. Dimension:Text:Get=`=LowerBound ':' =UpperBound`
  1854.  
  1855. Procedure:Category=Executable
  1856. Procedure:Objects=T:P:0M::"Parameters":Parameter
  1857. Procedure:Reference:"Parameters":Text1=`!'(' \N {>Parameter} EParametersIn \N')'`
  1858. Procedure:Reference:"Parameters":Text2=`!'RETURNS (' \N {>Parameter} EParametersOut \N ')'`
  1859. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  1860. Procedure:AttrReference:Text1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  1861. Procedure:AttrReference:Text2=where RDB$PROCEDURE_NAME='`O`'
  1862. Procedure:Warning=Loss
  1863. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1864. Procedure:Text:Init=CREATE PROCEDURE Procedure1 AS`\N`BEGIN`\N`END
  1865. Procedure:Text:Get1=CREATE PROCEDURE `N`
  1866. Procedure:Text:Get2=`{>Parameter} *`
  1867. Procedure:Text:Get3=AS `=Text`
  1868. Procedure:Text:RE=CREATE PROCEDURE\_+(\w+)\_*(.*)\_AS\_(.*)
  1869. Procedure:Text:Set=Text=3,*>Parameter=2,*N=1
  1870. Procedure:Modify:RE=(CREATE)\_+PROCEDURE
  1871. Procedure:Modify:Set=1=`'ALTER'`
  1872. Procedure:Delete:Text=DROP PROCEDURE `O`
  1873.  
  1874. Parameter:Category=Column
  1875. Parameter:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:-E::EResetType
  1876. Parameter:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:-E::EResetType
  1877. Parameter:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:-E::EResetType
  1878. Parameter:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:-E::EResetType
  1879. Parameter:Attrs:R=Type:"Domain":"Type":1:::ESetType
  1880. Parameter:AttrReference:FieldType=RDB$FIELD_SOURCE
  1881. Parameter:AttrReference:SubType=RDB$FIELD_SOURCE
  1882. Parameter:AttrReference:Length=RDB$FIELD_SOURCE
  1883. Parameter:AttrReference:Scale=RDB$FIELD_SOURCE
  1884. Parameter:EAttrs=Text
  1885. Parameter:Text:Get=`N ' ' EType`
  1886. Parameter:OnAfterLoad=AdjustTypeInfo
  1887.  
  1888. Function:Category=Executable
  1889. Function:Objects1=T:P:0M::"Parameters":FunctionParameter
  1890. Function:Objects2=T:P:11::"Result":FunctionResult
  1891. Function:Reference:"Parameters":Text=`[FunctionParameter:%s, %s:*]`
  1892. Function:Reference:"Result":Text=`[FunctionResult::*]`
  1893. Function:Warning=Loss
  1894. Function:EAttrs=Text,New,Delete,Modify,Rename,Save
  1895. Function:Text:Get1=DECLARE EXTERNAL FUNCTION `N \N`
  1896. Function:Text:Get2=`!'  ' {>FunctionParameter} * \N`
  1897. Function:Text:Get3=`'  RETURNS ' {>FunctionResult} * \N`
  1898. Function:Text:Get4= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  1899. Function:Delete:Text=DROP EXTERNAL FUNCTION `O`
  1900.  
  1901. FunctionParameter:Category=Column
  1902. FunctionParameter:Values=A.RDB$ARGUMENT_POSITION <> `:RDB$RETURN_ARGUMENT`
  1903. FunctionParameter:EAttrs=Text,New,Delete,Modify,Rename
  1904. FunctionParameter:Text:Get=`EPhysicalType`
  1905.  
  1906. FunctionResult:Category=Column
  1907. FunctionResult:Values=A.RDB$ARGUMENT_POSITION = `:RDB$RETURN_ARGUMENT`
  1908. FunctionResult:Attrs=RDB$MECHANISM=Kind="Kind"::E:::VM=TFnParamKind
  1909. FunctionResult:EAttrs=Text,New,Delete,Modify,Rename
  1910. FunctionResult:Text:Get=`EPhysicalType``! ' ' =Kind`
  1911.  
  1912. BlobFilter:Category=Executable
  1913. BlobFilter:Warning=Loss
  1914. BlobFilter:EAttrs=Text,New,Delete,Modify,Rename,Save
  1915. BlobFilter:Text:Get1=DECLARE FILTER `N \N`
  1916. BlobFilter:Text:Get2= INPUT_TYPE `=InputType`  OUTPUT_TYPE `=OutputType``\N`
  1917. BlobFilter:Text:Get3= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  1918. BlobFilter:Delete:Text=DROP FILTER `O`
  1919.  
  1920. CheckConstraint:Category=Expression
  1921. CheckConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'CHECK'
  1922. CheckConstraint:Attrs:Q=Text=Memo::"Text"::ER
  1923. CheckConstraint:AttrReference:Text1=select t.RDB$TRIGGER_SOURCE
  1924. CheckConstraint:AttrReference:Text2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  1925. CheckConstraint:AttrReference:Text3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  1926. CheckConstraint:AttrReference:Text4=t.RDB$TRIGGER_TYPE=1 and
  1927. CheckConstraint:AttrReference:Text5=c.RDB$CONSTRAINT_NAME='`O`'
  1928. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1929. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N`  ADD CONSTRAINT CheckConstraint1`\N`  CHECK ()
  1930. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N\N`  CHECK (`=Text`)
  1931. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_+\((.*)\)
  1932. CheckConstraint:Text:Set=1=`{<}N`,Text=3,*N=2
  1933. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1934. ; Convert CHECK \((.*)\) in Text
  1935. CheckConstraint:OnAfterLoad=CheckConstraintLoaded
  1936.  
  1937. UniqueConstraint:Category=UniqueConstraint
  1938. UniqueConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'UNIQUE'
  1939. UniqueConstraint:Objects1=T:P:1M::"Columns":IndexColumn
  1940. UniqueConstraint:Objects2=P:R:M1::"Index":Index:<>Index
  1941. UniqueConstraint:Reference:"Columns"=RDB$INDEX_NAME
  1942. UniqueConstraint:Reference:"Index"=RDB$INDEX_NAME
  1943. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1944. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  1945. UniqueConstraint:Text:Get2=`\N`  UNIQUE `'(' [IndexColumn:%s, %s:N] ')'`
  1946. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1947.  
  1948. PrimaryKey:Category=PrimaryKey
  1949. PrimaryKey:Values=A.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
  1950. PrimaryKey:Objects1=T:P:1M::"Columns":IndexColumn
  1951. PrimaryKey:Objects2=P:R:M1::"Index":Index:<>Index
  1952. PrimaryKey:Reference:"Columns"=RDB$INDEX_NAME
  1953. PrimaryKey:Reference:"Index"=RDB$INDEX_NAME
  1954. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  1955. PrimaryKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  1956. PrimaryKey:Text:Get2=`\N`  PRIMARY KEY `'(' [IndexColumn:%s, %s:N] ')'`
  1957. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1958.  
  1959. ForeignKey:Category=ForeignKey
  1960. ForeignKey:Values=A.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
  1961. ForeignKey:Objects1=T:P:1M::"Columns":IndexColumn
  1962. ForeignKey:Objects2=P:R:M1::"Index":Index:<>Index
  1963. ForeignKey:Objects3=P:R:M1::"Reference Table":Table
  1964. ForeignKey:Reference:"Columns"=RDB$INDEX_NAME
  1965. ForeignKey:Reference:"Index"=RDB$INDEX_NAME
  1966. ForeignKey:Reference:"Reference Table"=Reference
  1967. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION=MatchOption
  1968. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE=UpdateRule
  1969. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE=DeleteRule
  1970. ForeignKey:Attrs:Q=Reference=String::"Reference":0
  1971. ForeignKey:Attrs:R=Table::::ER
  1972. ForeignKey:AttrReference:Reference1=select RDB$RELATION_NAME
  1973. ForeignKey:AttrReference:Reference2=from RDB$REF_CONSTRAINTS A, RDB$RELATION_CONSTRAINTS B
  1974. ForeignKey:AttrReference:Reference3=where A.RDB$CONST_NAME_UQ = B.RDB$CONSTRAINT_NAME
  1975. ForeignKey:AttrReference:Reference4=and A.RDB$CONSTRAINT_NAME = `:RDB$CONSTRAINT_NAME`
  1976. ForeignKey:AttrReference:MatchOption=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  1977. ForeignKey:AttrReference:UpdateRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  1978. ForeignKey:AttrReference:DeleteRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  1979. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  1980. ForeignKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  1981. ForeignKey:Text:Get2=`\N`  FOREIGN KEY `'(' [IndexColumn:%s, %s:N] ')'`
  1982. ForeignKey:Text:Get3=`\N`  REFERENCES `=Table`
  1983. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1984.  
  1985. Trigger:Category=Executable
  1986. Trigger:Attrs:Q=Text=Memo::"Text"::ER
  1987. Trigger:AttrReference:Text1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  1988. Trigger:AttrReference:Text2=where RDB$TRIGGER_NAME='`O`'
  1989. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  1990. Trigger:Text:Get1=CREATE TRIGGER `N` FOR `{<}N`
  1991. Trigger:Text:Get2=`="Type"` POSITION `="Position"``!\N=Text`
  1992. Trigger:Delete:Text=DROP TRIGGER `O`
  1993.  
  1994. [Informix Properties]
  1995. TLockMode:Values=Closed,B=PAGE:"Page",P=PAGE:"Page",R=ROW:"Row"
  1996. TUnique:Values=Closed,-=:"No",U=UNIQUE:"Yes",D=:"No"
  1997. TClustered:Values=Closed,=:"No",-=:"No",C=CLUSTER:"Yes"
  1998. TDescending:Values=Closed,1=ASC:"No",-1=DESC:"Yes"
  1999. TMode:Values=Closed,P=DBA,O=Owner
  2000. TDataType:Values1=Closed,0=`'CHAR(' =Length ')'`:CHAR,1=SMALLINT,2=INTEGER,3=FLOAT
  2001. TDataType:Values2=4=SMALLFLOAT,5=DECIMAL,6=SERIAL(1):SERIAL,7=DATE
  2002. TDataType:Values3=8=MONEY,10=DATETIME,11=BYTE,12=TEXT,13=VARCHAR,14=INTERVAL
  2003. TNull01:Values=Closed,0=:"Yes",1=NOT NULL:"No"
  2004.  
  2005. Informix:UserName=select user from informix.systables where tabid=99
  2006. Informix:Comments=--
  2007.  
  2008. Informix:Objects1=O:C:0M::"Tables":Table
  2009. Informix:Objects2=O:C:0M::"Views":View
  2010. Informix:Objects3=O:C:0M::"Synonyms":Synonym
  2011. Informix:Objects4=O:C:0M::"Procedures":Procedure
  2012.  
  2013. informix.systables:Key=tabid
  2014. informix.systables:Name=owner,tabname
  2015. informix.systables:Attrs1=created="Created"
  2016. informix.systables:Attrs2=locklevel="Lock Mode":2::::VM=TLockMode
  2017. informix.systables:Attrs3=fextsize="Initial Extent (K)":2
  2018. informix.systables:Attrs4=nextsize="Extent (K)":2
  2019. informix.systables:Attrs5=rowsize="Row Size":2
  2020. informix.systables:Attrs6=nrows="Rows":2
  2021. informix.systables:Attrs7=npused="Pages":2
  2022.  
  2023. informix.sysconstraints:Key=tabid,constrid
  2024. informix.sysconstraints:Name=owner,constrname
  2025.  
  2026. informix.sysindexes:Key=tabid,owner,idxname
  2027. informix.sysindexes:Name=owner,idxname
  2028. informix.sysindexes:Attrs1=idxtype="Unique"::E:::VM=TUnique
  2029. informix.sysindexes:Attrs2=clustered="Clustered"::E:::VM=TClustered
  2030. informix.sysindexes:Attrs3=levels="Levels":2,leaves="Leaves":2
  2031. informix.sysindexes:Attrs4=clust="Clustering Factor":2
  2032.  
  2033. informix.sysprocedures:Key=procid
  2034. informix.sysprocedures:Name=owner,procname
  2035. informix.sysprocedures:Attrs1=mode="Mode":::::VM=TMode
  2036. informix.sysprocedures:Attrs2=codesize="Code Size"
  2037. informix.sysprocedures:Attrs3=datasize="Data Size"
  2038. informix.sysprocedures:Attrs4=retsize="Values Size":2
  2039. informix.sysprocedures:Attrs5=symsize="Symbols Size":2
  2040.  
  2041. Table:Definition=Root=informix.systables
  2042. View:Definition=Root=informix.systables
  2043. Synonym:Definition=Root=informix.systables
  2044. Index:Definition=Root=informix.sysindexes
  2045. PrimaryKey:Definition=Root=informix.sysconstraints
  2046. ForeignKey:Definition=Root=informix.sysconstraints
  2047. UniqueConstraint:Definition=Root=informix.sysconstraints
  2048. CheckConstraint:Definition=Root=informix.sysconstraints
  2049. Procedure:Definition=Root=informix.sysprocedures
  2050.  
  2051. Table:Category=Dataset
  2052. Table:Values=A.tabtype = 'T'
  2053. Table:Objects1=Q:P:1M::"Columns":Column
  2054. Table:Objects2=T:O:01::"Primary Key":PrimaryKey
  2055. Table:Objects3=T:O:0M::"Indices":Index
  2056. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  2057. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  2058. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  2059. Table:Attrs:R=locklevel::::E,fextsize::::E,nextsize::::E
  2060. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *]\N`
  2061. Table:Warning=DataLoss
  2062. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2063. Table:Text:Get1=CREATE TABLE `N` (`{>Column}*`)
  2064. Table:Text:Get2=`! ' EXTENT SIZE ' =fextsize``! ' NEXT SIZE ' =nextsize`
  2065. Table:Text:Get3=`! ' LOCK MODE ' =locklevel`
  2066. Table:Delete:Text=DROP TABLE `O`
  2067. Table:Rename:Text=RENAME TABLE `O` TO `N1`
  2068.  
  2069. View:Category=Dataset
  2070. View:Values=A.tabtype = 'V'
  2071. View:Objects=Q:P:0M:NMDR:"Columns":Column
  2072. View:Attrs:Q=Text=String::"Text"::ER
  2073. View:AttrReference:Text1=select viewtext, seqno from informix.sysviews
  2074. View:AttrReference:Text2=where tabid=`:tabid` order by seqno
  2075. View:Warning=Loss
  2076. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2077. View:Text:Init=CREATE VIEW View1 AS SELECT
  2078. View:Text:Get=`=Text`
  2079. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  2080. View:Text:NameSet=1=`N`
  2081. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  2082. View:Text:Set=Text=0,*N=2
  2083. View:Delete:Text=DROP VIEW `O`
  2084.  
  2085. Synonym:Category=Dataset
  2086. Synonym:Values=A.tabtype IN ('P', 'S')
  2087. Synonym:Objects=P:R:M1::"Local Target":Table
  2088. Synonym:Attrs:T1=informix.syssyntable.servername=SName:"Server":::E
  2089. Synonym:Attrs:T2=informix.syssyntable.dbname=SDatabase:"Database":::E
  2090. Synonym:Attrs:T3=informix.syssyntable.owner=SOwner:"Owner":::E
  2091. Synonym:Attrs:T4=informix.syssyntable.tabname=STable:"Table":::E
  2092. Synonym:Attrs:T5=informix.syssyntable.btabid=TargetId:::0
  2093. Synonym:Attrs:R=Table::::E
  2094. Synonym:AttrReference:SName=tabid=tabid
  2095. Synonym:AttrReference:SDatabase=tabid=tabid
  2096. Synonym:AttrReference:SOwner=tabid=tabid
  2097. Synonym:AttrReference:STable=tabid=tabid
  2098. Synonym:AttrReference:TargetId=tabid=tabid
  2099. Synonym:Reference:"Local Target"=TargetId
  2100. Synonym:Warning=Loss
  2101. Synonym:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2102. Synonym:Text:Get1=CREATE SYNONYM `N` FOR
  2103. Synonym:Text:Get2=`!=SName'@'``!=SDatabase'.'``!=SOwner'.'``=STable``=Table`
  2104. Synonym:Text:RE=CREATE\_+SYNONYM\_+(\w+)
  2105. Synonym:Text:Set=*N=1
  2106. Synonym:Delete:Text=DROP SYNONYM `O`
  2107.  
  2108. Column:Definition1=Dataset=
  2109. Column:Definition2=SELECT tabid,colno,colname,collength as Length,colmin,colmax,
  2110. Column:Definition3=coltype-trunc(coltype/256)*256 as Type,trunc(coltype/256) as Null
  2111. Column:Definition4=FROM informix.syscolumns WHERE tabid=`=tabid`
  2112. Column:Dataset1=tabid=Integer,colname=String,colno=Word,Length=Integer
  2113. Column:Dataset2=colmin=Integer,colmax=Integer,Type=Word,Null=Word
  2114. Column:Category=Column
  2115. Column:Key=tabid,colno
  2116. Column:Name=colname
  2117. Column:Order=colno
  2118. Column:Attrs1=colno="Order":2:ER
  2119. Column:Attrs2=Type="Type"::ER:::VM=TDataType
  2120. Column:Attrs3=Length="Length"::E
  2121. Column:Attrs4=Null="Nulls"::E:::VM=TNull01
  2122. Column:EAttrs=Text,New,Delete,Modify,Rename
  2123. Column:Text:Get=`N ' ' EType``! ' ' =Null`
  2124.  
  2125. Index:Category=Index
  2126. Index:Objects=M:P:1M::"Columns":IndexColumn:GetIndexColumns
  2127. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  2128. Index:Text:Get1=CREATE `=idxtype ' ' =clustered` INDEX `N`
  2129. Index:Text:Get2=ON `{<}N` (`{>IndexColumn}*`)
  2130. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  2131. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  2132. Index:Delete:Text=DROP INDEX `O`
  2133. Index:Reference:"Columns":Text=`[IndexColumn:%s,%s:\N '  ' *]\N`
  2134.  
  2135. IndexColumn:Category=ColumnReference
  2136. IndexColumn:Definition=Dataset
  2137. IndexColumn:Dataset=ItemNo=Integer,ColNo=Integer,Descending=Integer
  2138. IndexColumn:Name=Column
  2139. IndexColumn:Order=ItemNo
  2140. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  2141. IndexColumn:Attrs1=ItemNo="Order":2:ER
  2142. IndexColumn:Attrs2=Descending="Descending"::E:::VM=TDescending
  2143. IndexColumn:Attrs:R=Column::Descending:2:ER
  2144. IndexColumn:Reference:"Column"=,ColNo
  2145. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  2146. IndexColumn:Text:Get=`N ' ' =Descending`
  2147.  
  2148. ForeignColumn:Category=ColumnReference
  2149. ForeignColumn:Definition=Dataset
  2150. ForeignColumn:Dataset=ItemNo=Integer,ColNo=Integer,Descending=Integer
  2151. ForeignColumn:Name=Column
  2152. ForeignColumn:Order=ItemNo
  2153. ForeignColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  2154. ForeignColumn:Attrs1=ItemNo="Order":2:ER
  2155. ForeignColumn:Attrs:R=Column::Descending:2:ER
  2156. ForeignColumn:Reference:"Column"=,ColNo
  2157. ForeignColumn:EAttrs=Text,New,Delete,Modify,Rename
  2158. ForeignColumn:Text:Get=`N`
  2159.  
  2160. PrimaryKey:Category=PrimaryKey
  2161. PrimaryKey:Values=A.constrtype = 'P'
  2162. PrimaryKey:Objects1=P:R:M1::"Index":Index:<>Index
  2163. PrimaryKey:Objects2=M:P:1M::"Columns":IndexColumn:GetKeyColumns
  2164. PrimaryKey:Reference:"Index"=owner=owner,idxname=idxname
  2165. PrimaryKey:Reference:"Columns":Text=`[IndexColumn:%s,%s:N]\N`
  2166. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2167. PrimaryKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT
  2168. PrimaryKey:Text:Get2=PRIMARY KEY (`{>IndexColumn}*`) CONSTRAINT `N`
  2169. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2170.  
  2171. ForeignKey:Category=ForeignKey
  2172. ForeignKey:Values=A.constrtype = 'R'
  2173. ForeignKey:Objects1=P:R:M1::"Index":Index:<>Index
  2174. ForeignKey:Objects2=M:P:1M::"Columns":IndexColumn:GetKeyColumns
  2175. ForeignKey:Objects3=P:R:M1::"Reference Table":Table
  2176. ForeignKey:Objects4=P:P:0M::"Reference Columns":ForeignColumn
  2177. ForeignKey:Reference:"Index"=owner=owner,idxname=idxname
  2178. ForeignKey:Reference:"Columns":Text=`[IndexColumn:%s,%s:N]\N`
  2179. ForeignKey:Reference:"Reference"=ptabid
  2180. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2181. ForeignKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `\N`
  2182. ForeignKey:Text:Get2=FOREIGN KEY (`{>IndexColumn}*`) `\N`
  2183. ForeignKey:Text:Get3=REFERENCES `=Table` `!'('{>ForeignColumn}*')'` `\N`
  2184. ForeignKey:Text:Get4=CONSTRAINT `N`
  2185. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2186.  
  2187. CheckConstraint:Category=Expression
  2188. CheckConstraint:Values=A.constrtype = 'C'
  2189. CheckConstraint:Attrs:Q=Text=String::"Text"::ER
  2190. CheckConstraint:AttrReference:Text1=select checktext, seqno from "informix".syschecks
  2191. CheckConstraint:AttrReference:Text2=where constrid=`:constrid` and type='T'
  2192. CheckConstraint:AttrReference:Text3=order by seqno
  2193. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2194. CheckConstraint:Text:Init1=ALTER TABLE `{<}N\N`
  2195. CheckConstraint:Text:Init2= ADD CONSTRAINT CHECK ()`\N`  CONSTRAINT CheckConstraint1
  2196. CheckConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT CHECK (`=Text`)
  2197. CheckConstraint:Text:Get2=`\N`  CONSTRAINT `N`
  2198. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2199.  
  2200. UniqueConstraint:Category=UniqueConstraint
  2201. UniqueConstraint:Values=A.constrtype = 'U'
  2202. UniqueConstraint:Objects1=T:P:1M::"Columns":IndexColumn
  2203. UniqueConstraint:Objects2=P:R:M1::"Index":Index:<>Index
  2204. UniqueConstraint:Reference:"Index"=idxname
  2205. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2206. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT
  2207. UniqueConstraint:Text:Get2=UNIQUE (`{>IndexColumn}*`) CONSTRAINT `N`
  2208. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2209.  
  2210. Procedure:Category=Executable
  2211. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  2212. Procedure:AttrReference:Text1=select data, datakey, seqno from informix.sysprocbody
  2213. Procedure:AttrReference:Text2=where procid=`:procid` and datakey='T'
  2214. Procedure:AttrReference:Text3=order by datakey, seqno
  2215. Procedure:Warning=Loss
  2216. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2217. Procedure:Text:Init=CREATE PROCEDURE Procedure1
  2218. Procedure:Text:Get=`=Text`
  2219. Procedure:Text:NameRE=Text:PROCEDURE\_(\_*\w+)
  2220. Procedure:Text:NameSet=1=`N`
  2221. Procedure:Text:RE=CREATE(\_+DBA)?\_+PROCEDURE\_+(\w+).*
  2222. Procedure:Text:Set=Text=0,*N=2
  2223. Procedure:Delete:Text=DROP PROCEDURE `O`
  2224.  
  2225. [DB2 Common Server Properties]
  2226. TBooleanNY:Values=Closed,N=:"No",Y=:"Yes"
  2227. TBoolean01:Values=Closed,0=:"No",1=:"Yes"
  2228. TUpdateStatistics:Values=Closed,-1=
  2229. TNullNY:Values=Closed,N=NOT NULL:"No",Y=:"Yes"
  2230. TLoggedNY:Values=Closed,N=NOT LOGGED:"No",Y=LOGGED:"Yes"
  2231. TCompactNY:Values=Closed,N=NOT COMPACT:"No",Y=COMPACT:"Yes"
  2232. TDescending:Values=Closed,+=ASC:"No",-=DESC:"Yes"
  2233. TTypeKind:Values=Closed,S=:"System",T=:"Distinct"
  2234. TTypeId:Values1=Closed,124=BLOB,112=BOOLEAN,60=CHARACTER,44=CLOB,100=DATE,16=DECIMAL
  2235. TTypeId:Values2=8=DOUBLE,24=INTEGER,52=LONG VARCHAR,28=SMALLINT,104=TIME
  2236. TTypeId:Values3=108=TIMESTAMP,56=VARCHAR
  2237. TFunctionKind:Values=Closed,B=:"Built-in",E=:"External",U=:"Derived External",S=:"Generated"
  2238. TFunctionScalar:Values=Closed,C=:"No",S=:"Yes"
  2239. TVariantNY:Values=Closed,N=NOT VARIANT:"No",Y=VARIANT:"Yes"
  2240. TFencedNY:Values=Closed,N=NOT FENCED:"No",Y=FENCED:"Yes"
  2241. TNullCallNY:Values=Closed,N=NOT NULL CALL:"No",Y=NULL CALL:"Yes"
  2242. TExternalActionNY:Values=Closed,N=NO EXTERNAL ACTION:"No",E=EXTERNAL ACTION:"Yes"
  2243. TScratchPadNY:Values=Closed,N=NO SCRATCHPAD:"No",Y=SCRATCHPAD:"Yes"
  2244. TFinalCallNY:Values=Closed,N=NO FINAL CALL:"No",Y=FINAL CALL:"Yes"
  2245. TUnique:Values=Closed,D=:"No",U=UNIQUE:"Yes"
  2246. TValid:Values=Closed,N=:"No",Y=:"Yes",X=:"Rebind"
  2247. TDTFormat:Values=Closed,0=:"Country Code",1=:"USA",2=:"EUR",3=:"ISO",4=:"JIS",5="Local"
  2248. TIsolation:Values1=Closed,RR=:"Repeatable Read",RS=:"Read Stability"
  2249. TIsolation:Values2=CS=:"Cursor Stability",UR=:"Uncommitted Read"
  2250. TCursorBlocking:Values=Closed,N=:"No",U=:"Unambiguous",B=:"All"
  2251. TLanguageLevel:Values=Closed,0=SAA1,1=MIA
  2252. TExplainLevel:Values=Closed,A="All",P="Package"
  2253. TRule:Values1=Closed,A=NO ACTION:"No Action",C=CASCADE:"Cascade"
  2254. TRule:Values2=N=SET NULL:"Set Null",R=RESTRICT:"Restrict"
  2255. TTableStatus:Values=Closed,N=,C=:"Check pending",X=:"Inoperative"
  2256. TDataCaptureNY:Values=Closed,N=NONE:"No",Y=CHANGES:"Yes"
  2257. TTableSpaceType:Values1=Closed,S=SYSTEM USING ('filepath'):"System"
  2258. TTableSpaceType:Values2=D=DATABASE USING (DEVICE 'devicepath' size):"Database"
  2259. TTableSpaceData:Values=Closed,A=REGULAR:"All Permanent",L=LONG:"Long Data",T=TEMPORARY:"Temporary"
  2260. TTriggerValid:Values=Closed,X=:"No",Y=:"Yes"
  2261. TTriggerOrder:Values=Closed,B=:"Before",A=:"After"
  2262. TTriggerEvent:Values=Closed,I=:"On Insert",D=:"On Delete",U=:"On Update"
  2263. TTriggerGranularity:Values=Closed,S=:"Statement",R=:"Row"
  2264. TViewCheck:Values=Closed,N=,L=:"Local",C=:"Cascade"
  2265.  
  2266. DB2:UserName=select distinct user from syscat.datatypes
  2267. DB2:Comments=--
  2268.  
  2269. DB2:Objects1=O:C:0M::"Data Types":Type
  2270. DB2:Objects2=O:C:0M::"Tables":Table
  2271. DB2:Objects3=O:C:0M::"Views":View
  2272. DB2:Objects4=O:C:0M::"TableSpaces":TableSpace
  2273. DB2:Objects4=O:C:0M::"Aliases":Synonym
  2274. DB2:Objects5=O:C:0M::"Packages":Package
  2275. DB2:Objects6=O:C:0M::"Functions":Function
  2276.  
  2277. SYSCAT.CHECKS:Key=TABSCHEMA,TABNAME,CONSTNAME
  2278. SYSCAT.CHECKS:Name=CONSTNAME
  2279. SYSCAT.CHECKS:Attrs1=DEFINER="Owner"
  2280. SYSCAT.CHECKS:Attrs2=CREATE_TIME="Created"
  2281. SYSCAT.CHECKS:Attrs3=FUNC_PATH="Function Path":2
  2282. SYSCAT.CHECKS:Attrs4=TEXT="Text":3:ER
  2283.  
  2284. SYSCAT.COLCHECKS:Key=TABSCHEMA,TABNAME,CONSTNAME
  2285. SYSCAT.COLCHECKS:Name=CONSTNAME
  2286.  
  2287. SYSCAT.COLUMNS:Key=TABSCHEMA,TABNAME,COLNAME
  2288. SYSCAT.COLUMNS:Name=COLNAME
  2289. SYSCAT.COLUMNS:Order=COLNO
  2290. SYSCAT.COLUMNS:Objects=P:R:M1::"Type":Type
  2291. SYSCAT.COLUMNS:Attrs1=COLNO="Order":2:ER
  2292. SYSCAT.COLUMNS:Attrs2=LENGTH=Length="Length"::E
  2293. SYSCAT.COLUMNS:Attrs3=SCALE=Scale="Scale"::E
  2294. SYSCAT.COLUMNS:Attrs4=NULLS=Null="Nulls"::E:::VM=TNullNY
  2295. SYSCAT.COLUMNS:Attrs5=DEFAULT=Default="Default":2:E
  2296. SYSCAT.COLUMNS:Attrs6=LOGGED="Logged":2:E:::VM=TLoggedNY
  2297. SYSCAT.COLUMNS:Attrs7=COMPACT="Compacted":2:E:::VM=TCompactNY
  2298. SYSCAT.COLUMNS:Attrs8=CODEPAGE="Code Page":2
  2299. SYSCAT.COLUMNS:Attrs9=REMARKS="Comments":2
  2300. SYSCAT.COLUMNS:Reference:"Type"=TYPESCHEMA,TYPENAME
  2301.  
  2302. SYSCAT.DATATYPES:Name=TYPESCHEMA,TYPENAME
  2303. SYSCAT.DATATYPES:Attrs1=DEFINER="Owner"
  2304. SYSCAT.DATATYPES:Attrs2=METATYPE="Kind":::::VM=TTypeKind
  2305. SYSCAT.DATATYPES:Attrs3=LENGTH=Length="Length"::E
  2306. SYSCAT.DATATYPES:Attrs4=SCALE=Scale="Scale"::E
  2307. SYSCAT.DATATYPES:Attrs5=CREATE_TIME="Created"
  2308. SYSCAT.DATATYPES:Attrs6=CODEPAGE="Code Page":2
  2309. SYSCAT.DATATYPES:Attrs7=REMARKS="Comments":2
  2310.  
  2311. SYSCAT.FUNCPARMS:Key=FUNCSCHEMA,SPECIFICNAME,ORDINAL
  2312. SYSCAT.FUNCPARMS:Name=ORDINAL
  2313. SYSCAT.FUNCPARMS:Objects=P:R:M1::"Type":Type
  2314. SYSCAT.FUNCPARMS:Attrs1=LENGTH=Length="Length"::E
  2315. SYSCAT.FUNCPARMS:Attrs2=SCALE=Scale="Scale"::E
  2316. SYSCAT.FUNCPARMS:Attrs3=CODEPAGE="Code Page":2
  2317. SYSCAT.FUNCPARMS:Reference:"Type"=TYPESCHEMA,TYPENAME
  2318.  
  2319. SYSCAT.FUNCTIONS:Key=FUNCSCHEMA,SPECIFICNAME
  2320. SYSCAT.FUNCTIONS:Name=FUNCSCHEMA,SPECIFICNAME
  2321. SYSCAT.FUNCTIONS:Objects1=T:P:0M::"Parameters":FunctionParameter
  2322. SYSCAT.FUNCTIONS:Objects2=T:P:0M::"Result":Result
  2323. SYSCAT.FUNCTIONS:Attrs1=FUNCNAME="Function"
  2324. SYSCAT.FUNCTIONS:Attrs2=DEFINER="Owner"
  2325. SYSCAT.FUNCTIONS:Attrs3=ORIGIN="Origin":::::VM=TFunctionKind
  2326. SYSCAT.FUNCTIONS:Attrs4=TYPE="Scalar":::::VM=TFunctionScalar
  2327. SYSCAT.FUNCTIONS:Attrs5=CREATE_TIME="Created"
  2328. SYSCAT.FUNCTIONS:Attrs6=LANGUAGE="Language":2
  2329. SYSCAT.FUNCTIONS:Attrs7=IMPLEMENTATION="Implementation":2
  2330. SYSCAT.FUNCTIONS:Attrs8=VARIANT="Variant":2::::VM=TVariantNY
  2331. SYSCAT.FUNCTIONS:Attrs9=SIDE_EFFECTS="Side Effects":2::::VM=TExternalActionNY
  2332. SYSCAT.FUNCTIONS:Attrs10=FENCED="Fenced":2::::VM=TFencedNY
  2333. SYSCAT.FUNCTIONS:Attrs11=NULLCALL="NullCall":2::::VM=TNullCallNY
  2334. SYSCAT.FUNCTIONS:Attrs12=CAST_FUNCTION="Cast":2::::VM=TBooleanNY
  2335. SYSCAT.FUNCTIONS:Attrs13=ASSIGN_FUNCTION="Assignment":2::::VM=TBooleanNY
  2336. SYSCAT.FUNCTIONS:Attrs14=SCRATCHPAD="ScratchPad":2::::VM=TScratchPadNY
  2337. SYSCAT.FUNCTIONS:Attrs15=FINAL_CALL="Final Call":2::::VM=TFinalCallNY
  2338. SYSCAT.FUNCTIONS:Attrs16=REMARKS="Comments":2
  2339. SYSCAT.FUNCTIONS:Reference:"Parameters":Text=`[FunctionParameter:%s,%s:*]`
  2340. SYSCAT.FUNCTIONS:Reference:"Result":Text=`[Result:%s CAST FROM %s:*]`
  2341.  
  2342. SYSCAT.INDEXES:Name=INDSCHEMA,INDNAME
  2343. SYSCAT.INDEXES:Attrs1=DEFINER="Owner"
  2344. SYSCAT.INDEXES:Attrs2=UNIQUERULE="Unique"::E:::VM=TUnique
  2345. SYSCAT.INDEXES:Attrs3=USER_DEFINED="User Defined":::::VM=TBoolean01
  2346. SYSCAT.INDEXES:Attrs4=SYSTEM_REQUIRED="System Required":::::VM=TBoolean01
  2347. SYSCAT.INDEXES:Attrs5=CREATE_TIME="Created"
  2348. SYSCAT.INDEXES:Attrs6=STATS_TIME="Last Update Statistics"
  2349. SYSCAT.INDEXES:Attrs7=REMARKS="Comments":2
  2350. SYSCAT.INDEXES:Attrs8=NLEAF="Leaf Pages":2::::VM=TUpdateStatistics
  2351. SYSCAT.INDEXES:Attrs9=NLEVELS="Index Levels":2::::VM=TUpdateStatistics
  2352. SYSCAT.INDEXES:Attrs10=FIRSTKEYCARD="Distinct First Values":2::::VM=TUpdateStatistics
  2353. SYSCAT.INDEXES:Attrs11=FULLKEYCARD="Distinct Values":2::::VM=TUpdateStatistics
  2354. SYSCAT.INDEXES:Attrs12=CLUSTERRATIO="Cluster Ratio":2::::VM=TUpdateStatistics
  2355. SYSCAT.INDEXES:Attrs13=CLUSTERFACTOR="Cluster Factor":2::::VM=TUpdateStatistics
  2356. SYSCAT.INDEXES:Attrs14=COLNAMES=:4
  2357.  
  2358. SYSCAT.KEYCOLUSE:Key=TABSCHEMA,TABNAME,CONSTNAME,COLNAME
  2359. SYSCAT.KEYCOLUSE:Name=Column
  2360. SYSCAT.KEYCOLUSE:Order=COLSEQ
  2361. SYSCAT.KEYCOLUSE:Objects1=P:R:M1::"Column":Column:<<>Column
  2362. SYSCAT.KEYCOLUSE:Attrs1=COLSEQ="Order":2:ER
  2363. SYSCAT.KEYCOLUSE:Reference:"Column"=,,COLNAME
  2364.  
  2365. SYSCAT.PACKAGES:Name=PKGSCHEMA,PKGNAME
  2366. SYSCAT.PACKAGES:Objects=Q:C:0M::"Sections":Section
  2367. SYSCAT.PACKAGES:Attrs1=BOUNDBY="Bound By"
  2368. SYSCAT.PACKAGES:Attrs2=VALID="Valid":::::VM=TValid
  2369. SYSCAT.PACKAGES:Attrs3=TOTAL_SECT="Sections"
  2370. SYSCAT.PACKAGES:Attrs4=LAST_BIND_TIME="Last Bind"
  2371. SYSCAT.PACKAGES:Attrs5=EXPLICIT_BIND_TIME="Explicit Bind"
  2372. SYSCAT.PACKAGES:Attrs6=ISOLATION="Isolation Level":2::::VM=TIsolation
  2373. SYSCAT.PACKAGES:Attrs7=BLOCKING="Cursor Blocking":2::::VM=TCursorBlocking
  2374. SYSCAT.PACKAGES:Attrs8=LANG_LEVEL="Language Level":2::::VM=TLanguageLevel
  2375. SYSCAT.PACKAGES:Attrs9=FUNC_PATH="Function Path":2
  2376. SYSCAT.PACKAGES:Attrs10=FORMAT="Date Time Format":2::::VM=TDTFormat
  2377. SYSCAT.PACKAGES:Attrs11=CODEPAGE="Code Page":2
  2378. SYSCAT.PACKAGES:Attrs12=SQLWARN="SQL Warnings On":2::::VM=TBooleanNY
  2379. SYSCAT.PACKAGES:Attrs13=QUERYOPT="Optimization Class":2
  2380. SYSCAT.PACKAGES:Attrs14=EXPLAIN_LEVEL="Explain Level":2::::VM=TExplainLevel
  2381. SYSCAT.PACKAGES:Attrs15=EXPLAIN_SNAPSHOT="Explain Snapshot Active":2::::VM=TBooleanNY
  2382. SYSCAT.PACKAGES:Attrs16=REMARKS="Comments":2
  2383.  
  2384. SYSCAT.TABCONST:Key=TABSCHEMA,TABNAME,CONSTNAME
  2385. SYSCAT.TABCONST:Name=CONSTNAME
  2386. SYSCAT.TABCONST:Attrs1=DEFINER="Owner"
  2387. SYSCAT.TABCONST:Attrs2=REMARKS="Comments":2
  2388.  
  2389. SYSCAT.REFERENCES:Key=TABSCHEMA,TABNAME,CONSTNAME
  2390. SYSCAT.REFERENCES:Name=CONSTNAME
  2391. SYSCAT.REFERENCES:Objects1=T:P:1M::"Columns":KeyColumn
  2392. SYSCAT.REFERENCES:Objects2=P:R:M1::"Reference":Table
  2393. SYSCAT.REFERENCES:Attrs1=DEFINER="Owner"
  2394. SYSCAT.REFERENCES:Attrs2=CREATE_TIME="Created"
  2395. SYSCAT.REFERENCES:Attrs3=REFKEYNAME="Primary Key":2
  2396. SYSCAT.REFERENCES:Attrs4=DELETERULE="Delete Rule":2:E:::VM=TRule
  2397. SYSCAT.REFERENCES:Attrs5=UPDATERULE="Update Rule":2:E:::VM=TRule
  2398. SYSCAT.REFERENCES:Reference:"Columns":Text=`[KeyColumn:%s,%s:*]`
  2399. SYSCAT.REFERENCES:Reference:"Reference"=REFTABSCHEMA,REFTABNAME
  2400.  
  2401. SYSCAT.TABLES:Name=TABSCHEMA,TABNAME
  2402. SYSCAT.TABLES:Attrs1=DEFINER="Owner"
  2403. SYSCAT.TABLES:Attrs2=STATUS="Status":::::VM=TTableStatus
  2404. SYSCAT.TABLES:Attrs3=CREATE_TIME="Created"
  2405.  
  2406. SYSCAT.TABLESPACES:Name=TBSPACE
  2407. SYSCAT.TABLESPACES:Attrs1=DEFINER="Owner"
  2408. SYSCAT.TABLESPACES:Attrs2=TBSPACETYPE="Type":::::VM=TTableSpaceType
  2409. SYSCAT.TABLESPACES:Attrs3=DATATYPE="Data":::::VM=TTableSpaceData
  2410. SYSCAT.TABLESPACES:Attrs4=CREATE_TIME="Created"
  2411. SYSCAT.TABLESPACES:Attrs5=EXTENTSIZE="Extent Size":2
  2412. SYSCAT.TABLESPACES:Attrs6=PREFETCHSIZE="Prefetch Size":2
  2413. SYSCAT.TABLESPACES:Attrs7=OVERHEAD="Overhead":2
  2414. SYSCAT.TABLESPACES:Attrs8=TRANSFERRATE="Transfer Rate":2
  2415. SYSCAT.TABLESPACES:Attrs9=REMARKS="Comments":2
  2416.  
  2417. SYSCAT.TRIGGERS:Name=TRIGSCHEMA,TRIGNAME
  2418. SYSCAT.TRIGGERS:Attrs1=DEFINER="Owner"
  2419. SYSCAT.TRIGGERS:Attrs2=CREATE_TIME="Created"
  2420. SYSCAT.TRIGGERS:Attrs3=VALID="Valid":::::VM=TTriggerValid
  2421. SYSCAT.TRIGGERS:Attrs4=TRIGTIME="Order":::::VM=TTriggerOrder
  2422. SYSCAT.TRIGGERS:Attrs5=TRIGEVENT="On Event":::::VM=TTriggerEvent
  2423. SYSCAT.TRIGGERS:Attrs6=GRANULARITY="Granularity":::::VM=TTriggerGranularity
  2424. SYSCAT.TRIGGERS:Attrs7=FUNC_PATH="Function Path":2
  2425. SYSCAT.TRIGGERS:Attrs8=REMARKS="Comments":2
  2426.  
  2427. SYSCAT.VIEWS:Name=VIEWSCHEMA,VIEWNAME
  2428. SYSCAT.VIEWS:Attrs1=VIEWCHECK="Check Option":::::VM=TViewCheck
  2429. SYSCAT.VIEWS:Attrs2=READONLY="Read Only":::::VM=TBooleanNY
  2430. SYSCAT.VIEWS:Attrs3=FUNC_PATH="Function Path"
  2431.  
  2432. CheckConstraint:Category=Expression
  2433. CheckConstraint:Definition=Root=SYSCAT.TABCONST
  2434. CheckConstraint:Values=A.TYPE = 'K'
  2435. CheckConstraint:Attrs:T1=SYSCAT.CHECKS.CREATE_TIME=Created::REMARKS
  2436. CheckConstraint:Attrs:T2=SYSCAT.CHECKS.FUNC_PATH=FunctionPath::REMARKS
  2437. CheckConstraint:Attrs:T3=SYSCAT.CHECKS.TEXT=Text::REMARKS
  2438. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2439. CheckConstraint:Text:Init1=ALTER TABLE `{<}N\N`
  2440. CheckConstraint:Text:Init2= ADD CONSTRAINT CHECK () `\N`  CONSTRAINT CheckConstraint1
  2441. CheckConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N\N`  CHECK(`=Text`)
  2442. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2443.  
  2444. Column:Category=Column
  2445. Column:Definition=Root=SYSCAT.COLUMNS
  2446. Column:Attrs:R=Type:"Type":"Length":1:ER
  2447. Column:EAttrs=Text,New,Delete,Modify,Rename
  2448. Column:Text:Get=`N` `EType``! ' ' =Null``! ' WITH DEFAULT ' =Default``! ' ' =LOGGED``! ' ' =COMPACT`
  2449. Column:New:Text=ALTER TABLE `{<}N` ADD COLUMN `*`
  2450.  
  2451. Type:Category=Type
  2452. Type:Definition=Root=SYSCAT.DATATYPES
  2453. Type:Objects=P:R:M1::"Base Type":Type
  2454. Type:Attrs:R=Type::"Length":1:ER
  2455. Type:Warning=Loss
  2456. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  2457. Type:Reference:"Base Type"=SOURCESCHEMA,SOURCENAME
  2458. Type:Text:Init=CREATE DISTINCT TYPE Type1 AS `EType`
  2459. Type:Text:Get=CREATE DISTINCT TYPE `N` AS `EType`
  2460. Type:Delete:Text=DROP DISTINCT TYPE `O`
  2461.  
  2462. FunctionParameter:Category=Column
  2463. FunctionParameter:Definition=Root=SYSCAT.FUNCPARMS
  2464. FunctionParameter:Values=A.ROWTYPE = 'P'
  2465. FunctionParameter:Order=ORDINAL
  2466. FunctionParameter:Attrs1=ORDINAL="Order":2:ER
  2467. FunctionParameter:EAttrs=Text
  2468. FunctionParameter:Text:Get=`EType`
  2469.  
  2470. Result:Category=Column
  2471. Result:Definition=Root=SYSCAT.FUNCPARMS
  2472. Result:Values=A.ROWTYPE IN ('R', 'C')
  2473. Result:EAttrs=Text
  2474. Result:Text:Get=`EType`
  2475.  
  2476. Function:Category=Executable
  2477. Function:Definition=Root=SYSCAT.FUNCTIONS
  2478. Function:Objects=P:R:M1::"Source":Function
  2479. Function:Warning=Loss
  2480. Function:EAttrs=Text
  2481. Function:Text:Get1=CREATE FUNCTION `=FUNCNAME` (`{>FunctionParameter}*`)`\N ' '`
  2482. Function:Text:Get2=`' RETURNS ' {>Result}*` SPECIFIC `N``\N '  '`
  2483. Function:Text:Get3=`!'EXTERNAL NAME ' \Q =IMPLEMENTATION \Q`
  2484. Function:Text:Get4=`!' LANGUAGE ' =LANGUAGE ' PARAMETER STYLE DB2SQL ' =VARIANT ' ' =FENCED ' ' =NULLCALL ' NO SQL ' =SIDE_EFFECTS ' ' =SCRATCHPAD ' ' =FINAL_CALL`
  2485. Function:Text:Get5=`!'SOURCE SPECIFIC ' =Function`
  2486. Function:Delete:Text=DROP SPECIFIC FUNCTION `O`
  2487.  
  2488. Index:Category=Index
  2489. Index:Definition=Root=SYSCAT.INDEXES
  2490. Index:Objects=M:P:1M::"Columns":IndexColumn:GetIndexColumns
  2491. Index:Values=A.UNIQUERULE <> 'P'
  2492. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  2493. Index:Text:Get1=CREATE `=UNIQUERULE` INDEX `N`
  2494. Index:Text:Get2=ON `{<}N` (`{>IndexColumn}*`)
  2495. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  2496. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  2497. Index:Delete:Text=DROP INDEX `O`
  2498. Index:Reference:"Columns":Text=`[IndexColumn:%s,%s:*]`
  2499.  
  2500. IndexColumn:Category=ColumnReference
  2501. IndexColumn:Definition=Dataset
  2502. IndexColumn:Dataset1=ItemNo=Integer,ColName=String,Descending=String:1
  2503. IndexColumn:Name=Column
  2504. IndexColumn:Order=ItemNo
  2505. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  2506. IndexColumn:Attrs1=ItemNo="Order":2:ER
  2507. IndexColumn:Attrs2=Descending="Descending"::E:::VM=TDescending
  2508. IndexColumn:Attrs:R=Column::Descending:2:ER
  2509. IndexColumn:Reference:"Column"=,,ColName
  2510. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  2511. IndexColumn:Text:Get=`N ' ' =Descending`
  2512.  
  2513. Package:Definition=Root=SYSCAT.PACKAGES
  2514. Package:EAttrs=Delete,Save
  2515. Package:Delete:Text=DROP PACKAGE `O`
  2516.  
  2517. Section:Key=PKGSCHEMA,PKGNAME,SECTNO
  2518. Section:Name=SECTNO
  2519. Section:Definition1=Dataset=
  2520. Section:Definition2=SELECT SECTNO FROM SYSCAT.STATEMENTS
  2521. Section:Definition3=WHERE PKGSCHEMA='`O0`' AND PKGNAME='`O1`'
  2522. Section:Dataset=SECTNO=Integer
  2523. Section:Objects=Q:C:0M::"Statements":Statement
  2524. Section:EAttrs=
  2525.  
  2526. Statement:Name=STMTNO
  2527. Statement:Definition1=Dataset=
  2528. Statement:Definition2=SELECT STMTNO FROM SYSCAT.STATEMENTS
  2529. Statement:Definition3=WHERE PKGSCHEMA='`{<}O0`' AND PKGNAME='`{<}O1`' AND
  2530. Statement:Definition4=SECTNO=`:SECTNO`
  2531. Statement:Dataset=STMTNO=Integer
  2532. Statement:Attrs:Q=Text=Memo::"Text"
  2533. Statement:EAttrs=Text
  2534. Statement:Text:Get=`=Text`
  2535. Statement:AttrReference:Text1=SELECT TEXT, SEQNO FROM SYSCAT.STATEMENTS
  2536. Statement:AttrReference:Text2=WHERE PKGSCHEMA='`{<<}O0`' AND PKGNAME='`{<<}O1`'
  2537. Statement:AttrReference:Text3=AND SECTNO=`{<}:SECTNO` AND STMTNO=`:STMTNO`
  2538. Statement:AttrReference:Text4=ORDER BY SEQNO
  2539.  
  2540. PrimaryKey:Category=PrimaryKey
  2541. PrimaryKey:Definition=Root=SYSCAT.TABCONST
  2542. PrimaryKey:Values=A.TYPE = 'P'
  2543. PrimaryKey:Objects=T:P:1M::"Columns":KeyColumn
  2544. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2545. PrimaryKey:Text:Init1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT PrimaryKey1`\N '  '`
  2546. PrimaryKey:Text:Init2=PRIMARY KEY (`{>KeyColumn}*`)
  2547. PrimaryKey:Text:Get1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT `N \N '  '`
  2548. PrimaryKey:Text:Get2=PRIMARY KEY (`{>KeyColumn}*`)
  2549. PrimaryKey:Reference:"Columns":Text=`[KeyColumn:%s,%s:*]`
  2550. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2551.  
  2552. ForeignKey:Category=ForeignKey
  2553. ForeignKey:Definition=Root=SYSCAT.REFERENCES
  2554. ForeignKey:Attrs:T=SYSCAT.TABCONST.REMARKS=Comments
  2555. ForeignKey:Attrs:R=Table::::ER
  2556. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2557. ForeignKey:Text:Init1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT ForeignKey1
  2558. ForeignKey:Text:Init2=`\N`  FOREIGN KEY (`{>KeyColumn}*`) REFERENCES `=Table`
  2559. ForeignKey:Text:Init3=`\N`  ON DELETE `=DELETERULE \N '  '`ON UPDATE `=UPDATERULE`
  2560. ForeignKey:Text:Get1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT `N`
  2561. ForeignKey:Text:Get2=`\N`  FOREIGN KEY (`{>KeyColumn}*`) REFERENCES `=Table`
  2562. ForeignKey:Text:Get3=ON DELETE `=DELETERULE \N '  '`ON UPDATE `=UPDATERULE`
  2563. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2564.  
  2565. KeyColumn:Category=ColumnReference
  2566. KeyColumn:Definition=Root=SYSCAT.KEYCOLUSE
  2567. KeyColumn:Attrs:R=Column:::2:ER
  2568. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  2569. KeyColumn:Text:Get=`N`
  2570.  
  2571. Table:Category=Dataset
  2572. Table:Definition=Root=SYSCAT.TABLES
  2573. Table:Values=A.TYPE = 'T'
  2574. Table:Objects1=T:P:1M::"Columns":Column
  2575. Table:Objects2=T:O:01::"Primary Key":PrimaryKey
  2576. Table:Objects3=T:O:0M::"Indices":Index
  2577. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  2578. Table:Objects5=T:O:0M::"Check Constraints":CheckConstraint
  2579. Table:Objects6=T:O:0M::"Triggers":Trigger
  2580. Table:Objects7=P:R:M1::"Table Space":TableSpace
  2581. Table:Objects8=P:R:M1::"Index Space":TableSpace
  2582. Table:Objects9=P:R:M1::"Long Space":TableSpace
  2583. Table:Attrs1=DATACAPTURE="Data Capture":2:E:::VM=TDataCaptureNY
  2584. Table:Attrs2=STATS_TIME="Update Statistics":2
  2585. Table:Attrs3=CARD="Row Count":2::::VM=TUpdateStatistics
  2586. Table:Attrs4=NPAGES="Used Pages":2::::VM=TUpdateStatistics
  2587. Table:Attrs5=FPAGES="Total Pages":2::::VM=TUpdateStatistics
  2588. Table:Attrs6=OVERFLOW="Overflow Rows":2::::VM=TUpdateStatistics
  2589. Table:Attrs7=REMARKS="Comments":2
  2590. Table:Attrs:R1="Table Space"::::E
  2591. Table:Attrs:R2="Index Space"::::E
  2592. Table:Attrs:R3="Long Space"::::E
  2593. Table:Warning=DataLoss
  2594. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2595. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *]\N`
  2596. Table:Reference:"Indices"=TABSCHEMA=TABSCHEMA,TABNAME=TABNAME
  2597. Table:Reference:"Triggers"=TABSCHEMA=TABSCHEMA,TABNAME=TABNAME
  2598. Table:Reference:"Table Space"=TBSPACE
  2599. Table:Reference:"Index Space"=INDEX_TBSPACE
  2600. Table:Reference:"Long Space"=LONG_TBSPACE
  2601. Table:Text:Get1=CREATE TABLE `N` (`{>Column}*`)
  2602. Table:Text:Get2=`!\N'  DATA CAPTURE ' =DATACAPTURE`
  2603. Table:Text:Get3=`!\N'  IN ' ="Table Space"`
  2604. Table:Text:Get4=`!\N'  INDEX IN ' ="Index Space"`
  2605. Table:Text:Get5=`!\N'  LONG IN ' ="Long Space"`
  2606. Table:Delete:Text=DROP TABLE `O`
  2607.  
  2608. TableSpace:Definition=Root=SYSCAT.TABLESPACES
  2609. TableSpace:Warning=Loss
  2610. TableSpace:EAttrs=Text
  2611. TableSpace:Text:Get1=CREATE `=DATATYPE` TABLESPACE `N\N`
  2612. TableSpace:Text:Get2=MANAGED BY `=TBSPACETYPE`
  2613. TableSpace:Text:Get3=`! ' EXTENTSIZE ' =EXTENTSIZE`
  2614. TableSpace:Text:Get4=`! ' PREFETCHSIZE ' =PREFETCHSIZE`
  2615. TableSpace:Text:Get5=`! ' OVERHEAD ' =OVERHEAD`
  2616. TableSpace:Text:Get6=`! ' TRANSFERRATE ' =TRANSFERRATE`
  2617. TableSpace:Delete:Text=DROP TABLESPACE `O`
  2618.  
  2619. Synonym:Category=Dataset
  2620. Synonym:Definition=Root=SYSCAT.TABLES
  2621. Synonym:Values=A.TYPE = 'A'
  2622. Synonym:Attrs1=BASE_TABSCHEMA="Target Schema"
  2623. Synonym:Attrs2=BASE_TABNAME="Target Object"
  2624. Synonym:Attrs3=REMARKS="Comments":2
  2625. Synonym:Warning=Loss
  2626. Synonym:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2627. Synonym:Text:Get1=CREATE ALIAS `N` FOR `' '`
  2628. Synonym:Text:Get2=`! '"' =BASE_TABSCHEMA '".' ``'"' =BASE_TABNAME '"'`
  2629. Synonym:Delete:Text=DROP ALIAS `O`
  2630.  
  2631. View:Category=Dataset
  2632. View:Definition=Root=SYSCAT.TABLES
  2633. View:Values=A.TYPE = 'V'
  2634. View:Objects=T:P:0M:NMDR:"Columns":Column
  2635. View:Attrs=REMARKS="Comments":2
  2636. View:Attrs:T1=SYSCAT.VIEWS.VIEWCHECK=ViewCheck
  2637. View:Attrs:T2=SYSCAT.VIEWS.READONLY=ReadOnly
  2638. View:Attrs:T3=SYSCAT.VIEWS.FUNC_PATH=FunctionPath
  2639. View:Attrs:Q=Text=Memo::"Text"::ER
  2640. View:AttrReference:Text1=SELECT TEXT, SEQNO FROM SYSCAT.VIEWS
  2641. View:AttrReference:Text2=WHERE VIEWSCHEMA='`O0`' AND VIEWNAME='`O1`'
  2642. View:AttrReference:Text3=ORDER BY SEQNO
  2643. View:Warning=Loss
  2644. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2645. View:Text:Init=CREATE VIEW View1 AS `\N`  SELECT * FROM "owner"."table"
  2646. View:Text:Get=`=Text`
  2647. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  2648. View:Text:NameSet=1=`N`
  2649. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  2650. View:Text:Set=Text=0,*N=2
  2651. View:Delete:Text=DROP VIEW `O`
  2652.  
  2653. Trigger:Category=Executable
  2654. Trigger:Definition=Root=SYSCAT.TRIGGERS
  2655. Trigger:Attrs:Q=Text=Memo::"Text"::ER
  2656. Trigger:AttrReference:Text1=SELECT TEXT FROM SYSCAT.TRIGGERS
  2657. Trigger:AttrReference:Text2=WHERE TRIGSCHEMA='`O0`' AND TRIGNAME='`O1`'
  2658. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  2659. Trigger:Text:Get=`=Text`
  2660. Trigger:Delete:Text=DROP TRIGGER `O`
  2661.  
  2662.